update tableA set Gender = (case gender ='Male' then 'Female' else 'Male' end)
Subscribe to:
Post Comments (Atom)
-
What is Common Table Expression: Ans: A CTE (Common Table Expression) defines a temporary result set which you can then use in a SELECT...
-
What is SQL Server Profiler: The SQL Server Profiler is a performance tool which included with any version of SQL Server. It generally shows...
-
Difference Between Primary key & Foreign key Primary Key Foreign Key Helps you to uniquely identify a record in the table. It is...
No comments:
Post a Comment