摘要： declare @cnum varchar(20)declare @sql nvarchar(1000)select @sql=('select @a=cNumber+1 from VoucherHistory where CardNumber='''+@CardNumber+'''')exec sp_executesql @sql,N'@a int output',@cnum outputprint @cnum 阅读全文