Discussion in 'SQL Server 2008 General DBA Questions' started by RVG, Jan 14, 2010.
What is the difference between isnull and is null?
isnull is a function Replaces NULL with the specified value.
declare @qty int
set @qty = null
select ISNULL (@qty,0) -- replace qty with 0
result : 0
IS NULL : is operator to check whether a specified expression is NULL in sql statements
SELECT id, Name
WHERE name IS NULL
Separate names with a comma.