create public database link REMOTE_CONNECT connect to username identified by password using 'connect string' select * into table_remote@REMOTE_CONNECT from table
是SQL SERVER 还是ORACLE ?
1.在server2上执行sp_addlink 'server1' 2.在server2上执行: use love select * into table_1 from server1.zha.table_1
请给我个完整的语句
如能实现我请客。
connect to username identified by password
using 'connect string'
select * into table_remote@REMOTE_CONNECT from table
2.在server2上执行:
use love
select * into table_1 from server1.zha.table_1