--from zjcxc (Zou Jian) @ 9cbs - After modification - use dynamic SQL statements
Declare @s nvarchar (4000) Declare @sql nvarchar (4000) set @S = '' select @ s = case a.name when 'id' Ten @S else @S ', [' a.name ']' endfrom mytmp01.dbo.syscolumns a, mytmp02.dbo.syscolumns bwhere a.name = b.name and a.id = object_id ( 'mytmp01.dbo.tbl_tmp1') and b.id = object_id ( 'mytmp02.dbo.tbl_tmp1') Set @ s = stuff (@ s, 1, 1, '')
Set @ SQL = 'INSERT INTO MyTMP02.DBO.TBL_TMP1 (' @S ') SELECT' @S 'from mytmp01.dbo.tbl_tmp1where id = -1'select @ SQL - EXEC (@SQL)
