INSERT kaohe (xingming,bm)
SELECT xingming,bm
FROM zongbiao where bm='aa'测试通过,但我现在想再加几个用户定义的字段,比如说insert kaohe(xingming,bm,time),xingming,bm最好还是从zongbiao中得到,time就是获取当前时间!
SELECT xingming,bm
FROM zongbiao where bm='aa'测试通过,但我现在想再加几个用户定义的字段,比如说insert kaohe(xingming,bm,time),xingming,bm最好还是从zongbiao中得到,time就是获取当前时间!
SELECT xingming,bm,getdate()
FROM zongbiao where bm='aa'