现在有两张表T1和T2，T1中有字段C1，C2，C3，D1 T2中有字段C1，C2，C3，现在我要根据T2中的字段在T1中查询数据然后把这些数据插入到T2表中，该怎么写sql语句？
------解决方案--------------------
- SQL code
gocreate table t1(C1 INT,C2 INT,C3 INT)gocreate table t2(C1 INT,C2 INT,C3 INT,D1 INT)declare @str varchar(2000)set @str=''select @[email protected]+','+name from syscolumns where id=object_id('t1')and exists(select 1 from(select name from syscolumns where id=object_id('t2'))a where a.name=name)set @str='insert t2 select '+right(@str,len(@str)-1)+' from t1'print @str--insert t2 select C1,C2,C3 from t1--你只需动态执行exec(@str)