SQL简单语句

[智者潜行]

select * from Operator where Username in('admin2','cai','admin','ccccccc')

-------------------------------------
declare @a varchar(500)
set select @a=[U_power] from UserGroup  where U_ID='1'


begin
select * from Operator where Username in(''''+(replace(@a,',',''','''))+'''')
end
-------------------------

@a的值是admin2,cai,admin,ccccccc'
为什么执行第一句就有数据
执行下行的就没数据

[dawugui]

select * from Operator where charindex(Username ,@a) > 0

[-狙击手-]

declare @a varchar(500)
set select @a=[U_power] from UserGroup where U_ID='1'


－－－
declare @a varchar(500)
select @a=[U_power] from UserGroup where U_ID='1'

[sdhdy]

select @a=[U_power] from UserGroup  where U_ID='1'

[sdhdy]

--或者
set @a=(select [U_power] from UserGroup  where U_ID='1')

[智者潜行]

我想问是怎么回事..麻烦达人回答下[Quote=引用 1 楼 dawugui 的回复:]
SQL codeselect * from Operator where charindex(Username ,@a) > 0
[/Quote]

[-狙击手-]

估计你的意思应该是这样


declare @a varchar(500)
select @s = isnull(@a+''',''','''')+[U_power] from UserGroup where U_ID='1'
set @s = @s +''''

exec('select * from Operator where Username in('+@a+')')

[dawugui]

[Quote=引用 5 楼 lfoy112 的回复:]
我想问是怎么回事..麻烦达人回答下引用 1 楼 dawugui 的回复:
SQL codeselect * from Operator where charindex(Username ,@a) > 0
[/Quote]
你那个写法不对.得用楼上的动态SQL才行.

[中国风]

declare @a varchar(500)
set @a=','
select @a=@a+[U_power]+',' from UserGroup  where U_ID='1'


begin
select * from Operator where patindex(','+Username+',',@a)>0
end

declare @a varchar(500)
set @a=','
select @a=@a+[U_power]+',' from UserGroup  where U_ID='1'


begin
select * from Operator where @a like '%,'+Username+',%'
end

[智者潜行]

对,只有你的可以,其它答案都不可以.

就是把查询得到的数据admin2,cai,admin,ccccccc
替换成'admin2','cai','admin','ccccccc'
再进行查找
[Quote=引用 7 楼 dawugui 的回复:]
引用 5 楼 lfoy112 的回复:
我想问是怎么回事..麻烦达人回答下引用 1 楼 dawugui 的回复:
SQL codeselect * from Operator where charindex(Username ,@a) > 0

你那个写法不对.得用楼上的动态SQL才行.
[/Quote]

[sdhdy]

declare @a varchar(500)
--或者
set @a=(select [U_power] from UserGroup  where U_ID='1')


begin
exec ('select * from Operator where Username in('+@a+')')
end