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.
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.
No comments:
Post a Comment