1。进行服务器的连接 USE master GO EXEC sp_addlinkedserver 'server', N'SQL Server' GO EXEC sp_addlinkedsrvlogin 'server', 'false', NULL, 'Sa', 'Pass' GO 2。然后执行: delete server.mainserver.dbo.tempinfo from server.mainserver.dbo.tempinfo as a, mainserver.dbo.info as b where a.Id=b.Id
delete server.mainserver.dbo.tempinfo from server.mainserver.dbo.tempinfo as a,mainserver.dbo.info as b where a.Id=b.Id or:delect server.mainserver.dbo.tempinfo where id in(select id from mainserver.dbo.info )
USE master
GO
EXEC sp_addlinkedserver
'server',
N'SQL Server'
GO
EXEC sp_addlinkedsrvlogin 'server', 'false', NULL, 'Sa', 'Pass'
GO
2。然后执行:
delete server.mainserver.dbo.tempinfo from server.mainserver.dbo.tempinfo as a,
mainserver.dbo.info as b where a.Id=b.Id
or:delect server.mainserver.dbo.tempinfo where id in(select id from mainserver.dbo.info )
晕死,这是什么道理