Software Engg,sql server 2005 | Software developer-Kshms
Friday, April 5, 2013
Compare IS Null and any value in sql where Clause
select * from
tablename
WHERE
((
COLUMN1
=
@
PARAM
)
OR
(
COLUMN1
IS
NULL
AND
@
PARAM
IS
NULL
))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment