Programming Hub

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Tuesday, July 7, 2020

SQL Server Gender Swap Query

UPDATE tableA 
   SET Gender = CASE  
                WHEN Gender = 'Male' THEN 'Female'  
                ELSE 'Male'  
                END
Posted by pkmarathe at 9:05 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2021 (5)
    • ▼  November (5)
      • SOLID Principle
      • Dependency Injection
      • Find 2nd ,3rd or Nth Highest salary using LINQ
      • Difference Between First() And FirstOrDefault()
      • Difference Between Throw and Throw ex in C#
  • ►  2020 (68)
    • ►  July (18)
    • ►  May (5)
    • ►  April (45)
Picture Window theme. Powered by Blogger.