SQL Server - what is the query to check the row (when id=5 row except other rows)in a table?

Hi Frndz,

 

Functionality:  Data is Blank or Null then Update other wise not

 

 

To achieve this task,

 

Check  Condition using ISNULL

 

UserName = CASE WHEN ISNULL(UserName ,'') = '' THEN 'abc'

 

Full Logic     :

 

UPDATE tblUserDeatil set   

UserName = CASE WHEN ISNULL(UserName,'') = '' THEN 'abc' ELSE username END,

    Email = CASE WHEN ISNULL(Email,'') = '' THEN 'def@ggg.com' ELSE Email END

WHERE ID= 5  

 

 

Hope this helpful!

Thanks