我如何将多个值传递到where条件列？ [英] How i pass multiple values into the where condition column ?

问题描述

我有一个查询，想要传递多个列值作为参数。



例如我在qquery下面我想要传递多个值而不是一个值 -

Hi,

I have a query and want to pass multiple column values as a parameter.

for example i have below qquery where i want to pass multiple values instead of one value-

SELECT DISTINCT prs.RiderId
 
FROM [dbo].[PlanRiderSet] prs
 
INNER JOIN [dbo].[PlanProductSet] pps
 
ON prs.PlanId = pps.PlanId
 
inner join [dbo].[PlanRider] pr
 
on pr.Id=prs.RiderId
 
WHERE pr.RiderIdNumber=604 /*Here I pass value like multiple means ‘604,601,605,703’ like this values are in table column values.*/
 
and pps.ProductId = (SELECT pps.ProductId
 
FROM [dbo].[CustomerXref] cxref
 
INNER JOIN [dbo].[CustomerPlanXref] cpxref
 
ON cpxref.Id = cxref.PlanXrefId
 
INNER JOIN [dbo].[Plan] p
 
ON p.Id = cpxref.PlanId
 
INNER JOIN [dbo].[PlanProductSet] pps
 
ON p.Id = pps.PlanId
 
WHERE cxref.PlanXrefId = 3598)
 
ORDER BY prs.RiderId

如何实现这一点

How do I achieve this

推荐答案

使用IN语句

http://msdn.microsoft.com/ru-ru/library/ms177682.aspx [ ^ ]

这篇关于我如何将多个值传递到where条件列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！