Monday, April 24, 2023

Write a query to Update the Male <->Female in SQL server

 update tableA set Gender = (case gender ='Male' then 'Female' else 'Male' end)

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to use SQL pagination using LIMIT and OFFSET

  How to extract just a portion of a larger result set from a SQL SELECT. LIMIT n is an alternative syntax to the FETCH FIRST n ROWS ONLY. T...

  • What is LDF and MDF
    Master Database Files (MDF) and Log Database Files (LDF) are the primary files created for each database in the SQL Server environment. M...
  • Difference between Join and Union
    The join such as INNER JOIN or LEFT JOIN combines columns from two tables while the UNION combines rows from two queries. In other words,...
  • what is SQL Profiler
    What is SQL Server Profiler: The SQL Server Profiler is a performance tool which included with any version of SQL Server. It generally shows...