Tuesday, April 24, 2012

How to check nullify in SQL SERVER

Select * from TblEmp where address IS NULL


Select * from TblEmp where address IS NOT NULL

Update TblEmp set empcode='E021' where address IS NOT NULL 

0 comments:

Post a Comment