declare @month varchar(6),@aa nvarchar(100),@bb nvarchar(100)
set @month='201109'
set @[email protected]'
set @[email protected]
print(@bb)
print(@aa)
现在有这样一种情况,[email protected],
[email protected]@[email protected]_201109
求解。
------解决方案--------------------
- SQL code
declare @month varchar(6),@aa nvarchar(100),@bb nvarchar(100)set @month='201109'set @[email protected]set @[email protected]print(@bb)print(@aa)
------解决方案--------------------
- SQL code
declare @month varchar(6),@aa nvarchar(100),@bb nvarchar(100)set @month='201109'set @[email protected]'set @[email protected]print(@bb)print(@aa)
------解决方案--------------------
------解决方案--------------------
- SQL code
declare @month varchar(6),@aa nvarchar(100),@bb nvarchar(100)set @month='201109'set @bb='select @[email protected]'exec sp_executesql @bb,[email protected] varchar(6),@aa nvarchar(100) output',@month,@aa outputprint(@aa)/*aa_201109*/