Example :-
UPDATE dbo.Tbl_Employee
SET LastName =
(
CASE WHEN (DepartmentName = 'EDP') THEN FirstName+ '-'+ LastName
ELSE (LastName+ '.'+ FirstName)
END
)
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment