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...
-
In this Blog we will discuss how index actually work and help improve the performance of the database. Clustered Index Structure: Employee...
No comments:
Post a Comment