Define variable to use with IN operator (T-SQL)

by 
DECLARE @MyList TABLE (Value INT)
INSERT INTO @MyList VALUES (1)
INSERT INTO @MyList VALUES (2)
INSERT INTO @MyList VALUES (3)
INSERT INTO @MyList VALUES (4)

SELECT *
FROM MyTable
WHERE MyColumn IN (SELECT Value FROM @MyList)

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. to select all the employees who have joined most recently under king
  3. How do I escape a single quote in SQL Server?
  4. Simple way to transpose columns and rows in SQL?
  5. Count work days between two dates
  6. Only inserting a row if it’s not already there
  7. Unpivot with column name
  8. Selecting data from two different servers in SQL Server
  9. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  10. SQL JOIN vs IN performance?
  11. Most efficient way in SQL Server to get date from date+time?
  12. Convert varchar into datetime in SQL Server
  13. TSQL Pivot without aggregate function
  14. How to generate a range of dates in SQL Server
  15. SQL RANK() versus ROW_NUMBER()
  16. Check if a row exists, otherwise insert
  17. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  18. How do I perform a GROUP BY on an aliased column in SQL Server?
  19. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  20. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  21. Alter user defined type in SQL Server
  22. Best equivalent for IsInteger in SQL Server
  23. Store multiple bit values in a single table column
  24. SQL Server equivalent to MySQL enum data type?
  25. Comma separated values in a database field
  26. Grant SELECT permission on a view, but not on underlying objects
  27. SQL – Call Stored Procedure for each record
  28. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. Date serial in SQL?

Leave a Comment