摘要：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 阅读全文

摘要：--创建存储过程IF EXISTS (SELECT * FROM sysobjects WHERE name='GetSplitString' AND xtype='p') DROP PROCEDURE dbo.GetSplitStringGOCREATE PROCEDURE dbo.GetSplitString @strID nvarchar(max) --以逗号隔开的字符串 ,@tableName nvarchar(50) output --临时表ASBEGIN declare @totalLength int declare @length in... 阅读全文