insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) select id,'1','0','1','2000','2000}','1',getdate() from users where name='jack'
insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) values (select id from users where name='jack','1','0','1','2000','2000}','1',getdate())
insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) select id,'1','0','1','2000','2000}','1',getdate() from users where name='jack'
楼上都是正解~! 或者declare @id char(X) select @id=id from users where name='jack' insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) values (@id,'1','0','1','2000','2000','1',getdate())
usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime)
select id,'1','0','1','2000','2000}','1',getdate()
from users where name='jack'
usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime)
select id,'1','0','1','2000','2000}','1',getdate()
from users where name='jack'
或者declare @id char(X)
select @id=id from users where name='jack'
insert into usecashnow (Userid,zoneid,sn,aid,point,cash,status,creatime) values (@id,'1','0','1','2000','2000','1',getdate())