使用由查询中的值组成的字符串

2021-09-16 00:00:00 sql vb.net sql-server

使用由查询中的值组成的字符串

Using a string which comprises of values in a query

所以这听起来可能是一个愚蠢的问题,但我从来没有做过这样的事情......

So this sounds probably likea stupid question but I've never done something liek this....

我有一个看起来像这样的字符串......

I have a string that looks like this....

ValueID = 123, 234, 345, 466, 456

我也有一个类似这样的查询...

I also have a query that goes like this...

 Select * from Tbl1 where SomeValue In (123,234,345, 466, 456)

所以我现在要做的是......

So what I'm trying to do now is this...

Select * from Tbl1 where someValue in (ValueID)

这样的事情可行吗?

推荐答案

我想你想使用动态查询:-

I think you wanna use dynamic query:-

下一个代码有帮助吗?

declare @ValueID varchar(200)
set @ValueID = '123, 234, 345, 466, 456'
exec ('Select * from Tbl1 where someValue in ('+ @ValueID +')')

相关文章