Is it possible to use a dynamic WHERE IN clause LIKE
SELECT * FROM sometable WHERE ID in(@id)
Aug 03 '10 at 03:25 PM
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Aug 03 '10 at 03:25 PM
Seen: 779 times
Last Updated: Aug 03 '10 at 03:25 PM
Fetch logical page TempDB Failed
How to calculate Row count?
What happens if I kill a cursor half way through?
Stop return value from appearing in results from stored proc
Can we use "Any" with a case statement?
TSQL Update Max & Sort
SQL credit card search refactor
Retrieve closest upper and lower values
Can we Achive using charindex or patindex function?
Using isnull() in the WHERE clause