34,838
社区成员




--有如下SQL语句,怎么写才能在dbo.ReturnOrderbyColumn()中使用在动态语句中定义的@RKEY:
DECLARE @SQL VARCHAR(1000)
SET @SQL='
DECLARE @RKEY INT
SET @RKEY=27781
SELECT * FROM DATA0050 '+dbo.ReturnOrderbyColumn(@RKEY)+'
'
PRINT @SQL
declare @table table (id int,col varchar(1))
insert into @table
select 101,'a' union all
select 201,'b' union all
select 301,'c' union all
select 409,'d'
declare @userid varchar(2000),
@sqlstr varchar(4000)
set @userid='201,102,301,104,199'
SELECT * FROM @table
WHERE CHARINDEX(','+CAST(id AS VARCHAR(4))+',',','+@userid+',')>0
/*
id col
----------- ----
201 b
301 c
*/