22,207
社区成员
发帖
与我相关
我的任务
分享
DECLARE @str nvarchar(max)
set @str='SELECT id=1,C.PHost,C.PUrl,'+@R1+' R1,'+@R2+' R2 '+ into dataResult+' FROM (SELECT PHost,PUrl FROM Data2 WHERE '+@condtion+' ) C'
exec (@str)
DECLARE @condtion nvarchar(255)
DECLARE @R1 nvarchar(255)
DECLARE @R2 nvarchar(255)
SELECT @condtion=A.Condtion from (
SELECT id = ROW_NUMBER() OVER (ORDER BY Condtion),* FROM ABC) A WHERE A.id=1
PRINT @condtion
SELECT @R1=B.R1,@R2=B.R2 from (
SELECT id = ROW_NUMBER() OVER (ORDER BY Condtion),* FROM ABC) B WHERE B.id=1
PRINT @R1
PRINT @R2
SELECT id=1,C.PHost,C.PUrl,@R1 R1,@R2 R2 FROM (
SELECT PHost,PUrl
FROM Data2
WHERE @condtion ) C
最后面 where条件后面的@condtion 怎么替换?DECLARE @Condtion nvarchar(255)
select @Condtion = A.Condtion from (
select id = row_number() over(order by condtion),* from abc) A where A.id = 1
print @condtion
declare @sql nvarchar(255)
set @sql = 'select * from Data2 '+' where '+@condtion
exec(@sql)