Declare @Col_table1 nvarchar(4000) ,@Col_table2 nvarchar(4000) ,@DySQL nvarchar(4000)
SELECT @Col_table1='',@Col_table2=''
SELECT @Col_table1=@Col_table1+COLUMN_NAME+','
From INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='table1'
AND COLUMNPROPERTY(Object_ID('table1'),COLUMN_NAME,'IsIdentity')=0
ORDER BY ORDINAL_POSITION
SELECT @Col_table2=@Col_table2+COLUMN_NAME+','
From INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='table2'
AND COLUMNPROPERTY(Object_ID('table2'),COLUMN_NAME,'IsIdentity')=0
ORDER BY ORDINAL_POSITION
SELECT @Col_table1=LEFT(@Col_table1,LEN(@Col_Table1)-1),@Col_Table2=LEFT(@Col_Table2,LEN(@Col_Table2)-1)
SET @DySQL=
' INSERT INTO table1 (' +@Col_Table1+')
SELECT '+@Col_Table2 +' From table2 '