INSERT INTO [dbname].[dbo].[tableName]
([ID]
)
select ID from openrowset ( 'SQLOLEDB' , '127.0.0.1' ; 'sa' ; 'sa' ,[dbname].[dbo].[tableName])
where status=0
INSERT INTO [dbname].[dbo].[tableName]
([ID]
)
select ID from openrowset ( 'SQLOLEDB' , '127.0.0.1' ; 'sa' ; 'sa' ,[dbname].[dbo].[tableName])
where status=0
转载于:https://www.cnblogs.com/Rannie/p/4552668.html