三个变量的条件组合 [英] WHERE CONDITION COMBINATION OF THREE VARIABLES

问题描述

尊敬的先生/女士，



iam在SQL查询中有条件。在哪里条件如果位置是10然后它应该得到10,15,20 id如何通过这三个变量



问候

dhana

Dear sir/Madam,

iam having where condition in SQL query . in where condition if the location is 10 then it should get 10,15,20 id's how to pass these three variables

Regards
dhana

推荐答案

您可以尝试 IN Operator SQL Server中的[ ^ ]。试试这个：

You can try IN Operator[^] in SQL Server. Try this:

SELECT * FROM TableName WHERE LocationID IN(10, 15, 20)

请参阅以下链接欲了解更多信息：

http://www.w3schools.com/sql/sql_in.asp [ ^ ]

- Amit

在你的如果你必须使用动态查询...例如

Hi,
In your case you have to use Dynamic Query... for example

-- Your SP variable : @LocIDs VARCHAR(100)
CREATE PROCEDURE ProListLoc
@LocIDs VARCHAR(100)
AS 
BEGIN 
   DECLARE @SqlQuery VARCHAR(1000)

   SELECT @SqlQuery='SELECT * FROM TableName WHERE LocationID IN('+ @LocIDs +')'
   PRINT @SqlQuery
   EXEC (@SqlQuery)
END
-- then you will get the details based on your Input to SP.
EXEC ProListLoc @LocIDs = '10,15,20'

问候，

GVPrabu

Regards,
GVPrabu

这篇关于三个变量的条件组合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！