http://www.sqlteam.com/article/implementing-a-dynamic-where-clause
SELECT Cus_Name,
Cus_City,
Cus_Country
FROM Customers
WHERE Cus_Name = COALESCE(@Cus_Name,Cus_Name) AND
Cus_City = COALESCE(@Cus_City,Cus_City) AND
Cus_Country = COALESCE(@Cus_Country,Cus_Country)
Friday, October 15, 2010
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
-
▼
2010
(42)
-
▼
October
(10)
- Designing User Interface Tips - MSDN article
- Nice Regular Expressions Tutorial
- Asymmetric Encryption
- The Art & Science of Storing Passwords (2006 article)
- MultiTouch Vista
- When using post-cache substitution
- Stored Procedures and PreCompilation
- Stored procedures can be written in C#
- implementing-a-dynamic-where-clause
- Difference between <%= and <%#
-
▼
October
(10)
No comments:
Post a Comment