关于存储过程的问题，恐怕要邹老师亲自出马了
下面是存储过程里的一些语句
select @sCrmstr= 'select scardno,nmoney from '+@sCrm+ '..kcardaccount where sCustomer_c= '+@sCustomer_c
exec (@sCrmstr)
我想问下应该怎么把上面那取到的2个值 赋给变量@scardno,@nmoney？
好麻烦，试了好多种方法都无效
[解决办法]
select @sCrmstr= 'select @scardno=scardno,nmoney from '+@sCrm+ '..kcardaccount where sCustomer_c= '+@sCustomer_c
exec sp_executesql @sCrmstr,N@scardno varchar(1000) out
--类似这样,用sp_executesql
[解决办法]
declare @scardno nvarchar(50),@nmoney nvarchar(50)
declare @sCrmstr nvarchar(4000)
declare @sCrm nvarchar(250),@sCustomer_c nvarchar(50)
select @sCrmstr= 'select @scardno=scardno,nmoney from '+@sCrm+ '..kcardaccount where sCustomer_c= '+@sCustomer_c
exec sp_executesql @sCrmstr,N '@scardnoint output ',@scardno output
select @scardno
[解决办法]
exec sp_executesql @sql ,N@scardno varchar(1000) out ,@scardno out
--这样
