ls0398 发表于 2016-10-29 10:43:02

SQL SERVER  2008

exec sp_addlinkedserver   'ITSV ', ' ', 'SQLOLEDB ', '192.169.1.13'
exec sp_addlinkedsrvlogin'ITSV ', 'false ',null, 'sa', '123'

select * from ITSV.gkhb_shzh.dbo.SYS_BASE_CODE

insert into SYS_BASE_CODE select * from ITSV.gkhb_shzh.dbo.SYS_BASE_CODE
页: [1]
查看完整版本: SQL SERVER  2008