Script for swapping gender in sql server through CASE (Without Using Cursor)

I want to share you my experience about an interview where i was asked to write script for swapping gender using cursor and without using cursor.
   In my previous post I mentioned "Script for swapping gender through CURSOR" .Here I am sharing swapping gender using CASE .

Step 1: First of all create a table ,here "genderTest"

            CREATE TABLE  genderTest (id nvarchar(20) PRIMARY KEY,empname nvarchar(20),gender           nvarchar(1))

Step 2:Now insert some values in table

       INSERT INTO gendertest VALUES ('1','ashish','m')
       INSERT INTO gendertest VALUES ('2','nandani','f')
       INSERT INTO gendertest VALUES ('3','chandrasen','m')
       INSERT INTO gendertest VALUES ('4','priynka','f')
       INSERT INTO gendertest VALUES ('5','sonam','f')
       INSERT INTO gendertest VALUES ('6','guru','m')
       INSERT INTO gendertest VALUES ('7','faisal','m')
       INSERT INTO gendertest VALUES ('8','priti','f')

Step 3: Execute following query


           UPDATE genderTest 
           SET gender=
          CASE gender
          WHEN 'f' THEN 'm'
          ELSE 'f'
      END
   Above script will swap gender.
    

Technology Improver: Script for swapping gender in sql server through Cursor

Technology Improver: Script for swapping gender in sql server through Cursor

Script for swapping gender in sql server through Cursor

Step 1:Create table ,here GenderConvert

--create table GenderConvert(name nvarchar(20),gender nvarchar(1))

Step 2:Insert some Values in table

--insert into genderconvert values('ashish', 'm' )

--insert into genderconvert values('sonam', 'f' )

--insert into genderconvert values('priya', 'f' )

--insert into genderconvert values('sonu', 'm' )

--insert into genderconvert values('anshu', 'f' )

--insert into genderconvert values('vinod', 'm' )

--insert into genderconvert values('pappu ', 'm' )

--insert into genderconvert values('pavan', 'm' )

--insert into genderconvert values('priynka', 'f' )

--insert into genderconvert values('sonali', 'f' )

--insert into genderconvert values('guru', 'm' )

STEP 3:Execute this script (cursor)

DECLARE @name nvarchar(20)

DECLARE @gender nvarchar(1)

DECLARE @MyCursor CURSOR

--Assign table to cursor variable

SET @MyCursor = CURSOR FOR 

SELECT name,gender FROM genderconvert

--Open cursor

OPEN @MyCursor

--Fetch cursor row on by one

FETCH NEXT 

FROM @MyCursor INTO @name , @gender

WHILE @@FETCH_STATUS = 0

BEGIN

if(@gender = 'm' )

BEGIN 

UPDATE  genderconvert set gender='f' where name=@name

END

else

BEGIN 

UPDATE  genderconvert set gender='m' where name=@name

END

FETCH NEXT FROM @MyCursor into  @name,@gender

END

           After executing this script gender will be swap.Please give your valuable review if this post helpful for you.