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
Select * from TblEmp where address IS NOT NULL
Update TblEmp set empcode='E021' where address IS NOT NULL
0 comments:
Post a Comment