下面是存储过程里的一些语句
select @sCrmstr= 'select scardno,nmoney from '[email protected]+ '..kcardaccount where sCustomer_c= '[email protected]_c
exec (@sCrmstr)
我想问下应该怎么把上面那取到的2个值 [email protected],@nmoney？
好麻烦，试了好多种方法都无效
------解决方案--------------------
select @sCrmstr= 'select @scardno=scardno,nmoney from '[email protected]+ '..kcardaccount where sCustomer_c= '[email protected]_c
exec sp_executesql @sCrmstr,[email protected] 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 '[email protected]+ '..kcardaccount where sCustomer_c= '[email protected]_c
exec sp_executesql @sCrmstr,N '@scardnoint output ',@scardno output
select @scardno
------解决方案--------------------
exec sp_executesql @sql ,[email protected] varchar(1000) out ,@scardno out
--这样