用触发器
create trigger triggername on tablename
for insert
as
insert newtablename(fieldnanelist) select fieldnamelist from inserted
create trigger triggername on tablename
for insert
as
insert newtablename(fieldnanelist) select fieldnamelist from inserted
EXEC sp_addlinkedserver
'别名',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
GO
然后你就可以如下:
select * from 别名.库名.dbo.表名
insert 库名.dbo.表名 select * from 别名.库名.dbo.表名
select * into 库名.dbo.新表名 from 别名.库名.dbo.表名
go