insert b(col1,col2) select col1,col2 from a 就这样就可以了啊,或者在后面加个条件
哎呀GG们好像会错我地意了啊,我在查询分析器里这样写报错啊, insert into klian(lkid,luser,ldian,lxin,lzhi,lcity,lchuan) values('select kid from kbiao where kuser = "eer"','你好','7656690','男','会计','郑州','7656690') 错误:服务器: 消息 8152,级别 16,状态 9,行 1 将截断字符串或二进制数据。 语句已终止。 要咋写那?
有没有办法让我的insert into klian(lkid,luser,ldian,lxin,lzhi,lcity,lchuan) values('select kid from kbiao where kuser = "二"','你好','7656690','男','会计','郑州','7656690') 执行那 现在他把'select kid from kbiao where kuser = "二"'当成一个字符添加了啊
insert into B select * from A
values('select kid,'" & userl.text & "','" & dianl.text & "','" & strtemp3 & "','" & zhil.text & "','" & cityl.text & "','" & jdianl.text & "','" & ydianl.text & "','" & chuanl.text & "','" & emaill.text & "','" & qql.text & "','" & xiul.text & "','" & shengl.text & "','" & beil.text & "' from kbiao where kuser = " & user.text )
select col1 from a
select col1,col2 from a 就这样就可以了啊,或者在后面加个条件
insert into klian(lkid,luser,ldian,lxin,lzhi,lcity,lchuan)
values('select kid from kbiao where kuser = "eer"','你好','7656690','男','会计','郑州','7656690')
错误:服务器: 消息 8152,级别 16,状态 9,行 1
将截断字符串或二进制数据。
语句已终止。
要咋写那?
values('select kid from kbiao where kuser = "二"','你好','7656690','男','会计','郑州','7656690')
执行那
现在他把'select kid from kbiao where kuser = "二"'当成一个字符添加了啊