sql case update

Solutions on MaxInterview for sql case update by the best coders in the world

Search
showing results for - "sql case update"
Eden
20 May 2018
1UPDATE dbo.TestStudents  
2SET     LASTNAME =  CASE  
3                        WHEN LASTNAME = 'AAA' THEN 'BBB' 
4                        WHEN LASTNAME = 'CCC' THEN 'DDD' 
5                        WHEN LASTNAME = 'EEE' THEN 'FFF' 
6                        ELSE LASTNAME
7                    END 
8WHERE   LASTNAME IN ('AAA', 'CCC', 'EEE')
9
source
similar questions
tsql case whensql caseupdate sqlupdate sql sintaxupdate select sqlcase in sqlsql update klauselcase when switch in sqlswitch case sql serverswitch case sql columnupdate values in select statement sqlsql update case sensitivesql update with statementcase statement in sqlsql update querysql updatesql case sttement with setcase insensitive sqlt sql casesql updatesql caseupdate in sqlupper case sqlhow to upper case in sql
queries leading to this page
sql update case rpgleupdate table case statement sqlsql update query case whensql update statement case whent sql update with case whenusing case statement in update query sqlsql update table case whent sql update set casesql case in updateupdate case sql serverupdate statement with a case statement in sqlwhy update with case statement in sqlcase when update sql serverhow to use case in update statement in sqlcase with an update statement sqlsql update case whenupdate case statement in sqlcase in update statement sql servert sql update with case statementupdate set case sqlupdate query with case statement in sqlsql update using case whenupdate records using case statement in sqlcase in update statementupdate with case when sqlupdate with case sql serversql update using caseupdate with case sqlupdate using case in sql serversql update case when sqlupdate statement in sql based on case statementusing update with case in sqlsql select case updatesql update query using caseupdate in sql using case statementsql update caseupdate case when sqlupdate in sql based on case statement resultsql update with caseupdate statement with case in sqlcase statement in update query sql serversql update with case wheresql case foe updateupdate select case sql queryhow to use case in sql update statementupdate value in case statement in sqlcase with update statement sqlcase condition in update statement in sqlcase with update in sqlsql select case update statementhow to update sql server using case statementupdate case sqlsql update with case whenupdate where case sql serverusing case in update statement in sqlsql 2b update caseupdate values using case sqlcall update query in case statement sqlupdate in case statement sqlcase when update querycase statement with update sqlupdate case query in sqlupdate with case statement in sqlcase in sql updatesql case updatecase update sqlsql update case statementcase then wit updae query sqlupdate case in sql serversql query update on casesql case update