4
Reply

Consider you have table Say TblEmployee with a column say EmployeeName which contain Records as A,B,A,A,B,C,B,C,Ayour task is to write a query which will change the EmployeeName A to B and B to A.

Sukesh Marla

Sukesh Marla
13y
3.3k
2
Reply
    Dasharath Vishwakarma
    CREATE table #TbleEmployee (EmployeeName varchar(10))insert into #TbleEmployee(EmployeeName)VALUES('A'),('B'),('A'),('A'),('B'),('C'),('B'),('C'),('A')update #TbleEmployee SETEmployeeName=(CASE EmployeeName WHEN 'A' THEN 'B' WHEN 'B' THEN 'A' ELSE EmployeeName END)
    Dasharath Vishwakarma
    11y
    3
    Sukesh Marla
    update TblEmployee 
    set EmpName = (CASE 
    WHEN EmpName='A' THEN 'B'
    WHEN EmpName='B' THEN 'A'
    ELSE EmpName
    END)
    Sukesh Marla
    13y
    3
    Divyanshu Tripathi
    You all have entered correct
    Divyanshu Tripathi
    10y
    1
    Rajeev Kumar

    update TblEmployee set EmpName = EmpName=’A’ THEN ‘B’
    WHEN EmpName=’B’ THEN ‘A’
    ELSE EmpName
    END

    Rajeev Kumar
    2y
    0
Message