请教

[会飞的小洋洋]

表a
id content
1 11,22,33,44,55,66
2 77,88,99

----------代码
declare @content varchar(200)
select top 1 @content=content from a
select * from orders where content in(@content)

----------如何实现以下查询的结果
select * from others where id in(11,22,33,44,55,66)

[paoluo]

用了動態語句了？!這種情況沒有必要使用動態語句的。

[ojuju10]

declare @content varchar(200)
select top 1 @content=content from a
exec('select * from orders where content in('+@content+')')

[昵称被占用了]

declare @content varchar(200)
select top 1 @content=content from a
exec('select * from orders where id in('+@content+')')

[$扫地僧$]

create table A
(
id int,
content varchar(100)
)

insert A select 1,'11,22,33,44,55,66'
insert A select 2,'77,88,99'

create table B
(
T int
)
insert B select 11
insert B select 22
insert B select 88

select * from B where charindex(cast(T as varchar),(select top 1 content from A ))>0

[paoluo]

--改用CharIndex，可以不用使用動態SQL語句
Select T1.* from orders T1
Inner Join a T2
On CharIndex(',' + Cast(T1.id As Varchar) + ',', ',' + T2.content + ',') > 0
Where T2.id = (Select TOP 1 id From a)

[paoluo]

--或者Like
Select T1.* from orders T1
Inner Join a T2
On ',' + T2.content + ',' Like '%,' + Cast(T1.id As Varchar) + ',%'
Where T2.id = (Select TOP 1 id From a)