一个INSERT INTO 的小问题 大家帮忙看看

Question

dim sql as string="insert into [Teacher_Backup](T_ID,T_SID,T_Name,T_Nation,T_Visage,T_Marry,T_Add,D_Name,O_Name,T_Clevel,T_Dgree,TL_Name,P_Name,TT_Direction,TT_Resume,TS_Status) values("+
"select T_ID,T_SID,T_Name,T_Nation,T_Visage,T_Marry,T_Add,D_ID,O_ID,T_Clevel,T_Dgree,TL_ID,P_ID,T_Direction,T_Resume,TS_Status from [Teacher_Info] where T_ID="+
"1004"+")";

Answer 1

dim sql as string="insert into [Teacher_Backup](T_ID,T_SID,T_Name,T_Nation,T_Visage,T_Marry,T_Add,D_Name,O_Name,T_Clevel,T_Dgree,TL_Name,P_Name,TT_Direction,TT_Resume,TS_Status) (select T_ID,T_SID,T_Name,T_Nation,T_Visage,T_Marry,T_Add,D_ID,O_ID,T_Clevel,T_Dgree,TL_ID,P_ID,T_Direction,T_Resume,TS_Status from [Teacher_Info] where T_ID='1004')"中间不能有values!!!

Answer 2

正解
dim sql as string="insert into [Teacher_Backup](T_ID,T_SID,T_Name,T_Nation,T_Visage,T_Marry,T_Add,D_Name,O_Name,T_Clevel,T_Dgree,TL_Name,P_Name,TT_Direction,TT_Resume,TS_Status) (select T_ID,T_SID,T_Name,T_Nation,T_Visage,T_Marry,T_Add,D_ID,O_ID,T_Clevel,T_Dgree,TL_ID,P_ID,T_Direction,T_Resume,TS_Status from [Teacher_Info] where T_ID='1004')"

Answer 3

严重同意aduan1026(阿段)
如果是全部字段匹配
dim sql as string="insert into [Teacher_Backup] select * from [Teacher_Info]"

Answer 4

那如果还有另外的值要插进去了 
怎么做
？那不是要在用一个UPDATE 语句修改啊

Answer 5

没人回啊 
自己顶一下
UP HARRY！！！