SQL数据转插入语句

转载

SELECT a.name, b.rows, 'insert into ' + a.name + '('+c.columns+')  select '+c.columns+' from [172.18.65.84].[TEST].[dbo].' + a.name + ';' 
FROM sysobjects AS a 
INNER JOIN sysindexes AS b ON a.id = b.id 
INNER JOIN 
(
	select id, columns=stuff((select ',['+name +']' from syscolumns where [name] !='OptimisticVersion' and id = col.id for xml path('')),1,1,'') from syscolumns as col 
	group by id  
) c on a.id = c.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))  and a.name like 'G%' and b.rows>0 
ORDER BY b.rows DESC