22,207
社区成员
发帖
与我相关
我的任务
分享
declare @a as nvarchar(50)
set @a='8c4af668-f81f-43e6-9bc4-8d06e2074282'
set @sql='insert into VehicleApply (Id,ApplyPerson,ApplyUnit,WBSCenter,FCNumber,GoTime,PassengersNum,purpose,CarContacts,ContactNumber,ApplyDate,Route,Sign,CTime) values (@a,''[admin]'',''asdf'',''adsf'',''11'',GETDATE(),11,''asdf'',''陈师傅'',''13313313131'',GETDATE(),''接人'',''0'',GETDATE())'
exec sp_executesql @sql
insert into VehicleApply (Id,ApplyPerson,ApplyUnit,WBSCenter,FCNumber,GoTime,PassengersNum,purpose,CarContacts,ContactNumber,ApplyDate,Route,Sign,CTime) values (@a,'[admin]','asdf','adsf','11',GETDATE(),11,'asdf','陈师傅','13313313131',GETDATE(),'接人','0',GETDATE())
declare @a as nvarchar(50)
,@sql varchar(2000)
set @a='8c4af668-f81f-43e6-9bc4-8d06e2074282'
set @sql='insert into VehicleApply (ID,ApplyPerson,ApplyUnit,WBSCenter,FCNumber,GoTime,PassengersNum,purpose,CarContacts,ContactNumber
,ApplyDate,Route,Sign,CTime) values ('''+@a+''',''[admin]'',''asdf'',''adsf'',''11'',GETDATE(),11,''asdf'',''陈师傅'',''13313313131'',GETDATE(),''接人'',''0'',GETDATE())'
print @sql
exec(@sql)
exec和sp_executesql是有区别的!