SQL WHERE List Matches Any or All
Posted by: HumanCompiler - Erik Porter (MS MVP) Blog,
on 26 Mar 2007 |
View original | Bookmarked: 0 time(s)
I saw a cool post recently from Jon Galloway called "Passing lists to SQL Server 2005 with XML Parameters". This is a pattern I've used several times while building the new version of Channel 9. If you'd like to learn how to pass in lists to stored procedures, check out Jon's post.One of the times I've used it is to search our database for all entries from two of our forums. For this example, we'll say Techoff and Sandbox. Once you have a...