Question

两条sql语句合并，或同时执行

insert into Sell(CustomerID) values(select CustomerID from Customer where Name=" + "\'" + name + "\'"
"insert into Sell(Time) values('" + DateTime.Now.ToString() + "')"
因为数据库里面CustomerID和Time都不允许为空，这两条语句要同时执行，或者合并，求高手赐教啊~
insert into Sell(CustomerID,Time) values((select CustomerID from

Customer where Name='" + name + "'),'"+System.DateTime.Now.ToString()+"')
最终ok的是这个~虽然都没Ok~很感谢大家的回答，

Answer 1

就是传两个值而已：
insert into Sell(CustomerID,Time) values((select CustomerID from Customer where Name=" + "\'" + name + "\'"),DateTme.Now.ToString());

Answer 2

insert into Sell(CustomerID)
(select CustomerID from Customer where Name=" + "\'" + name + "\'"
UNION ALL
insert into Sell(Time) values('" + DateTime.Now.ToString() + "')")

Answer 3

nsert into Sell(CustomerID,Time) values(select CustomerID from Customer where Name=" + "\'" + name + "\'", DateTime.Now)

Answer 4

sell（1，2）values（1，2）