Update with CASE statement

Question

Update with CASE statement

Viewing 9 posts - 46 through 54 (of 54 total)

You must be logged in to reply to this topic. Login to reply

Tony Bater SSCrazy Points: 2150 More actions · Answer 1

Oops again.:w00t:This time I didn't even read the objective correctly! for some reason I thought it was just to set all values of Gender to 'M'. Apologies to the question setter.

Tony

sqlnaive SSCoach Points: 17437 More actions · Answer 2

Very good question. Also good way to show how values can be swapped.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Lokesh Vij (2/18/2013)
For me the question was simple, clear and very basic. Thanks

+1

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sqlcentral-bugmenot SSC Enthusiast Points: 120 More actions · Answer 4

I, too caught on the (success OR failure), the collation-dependent field name, and the missed shorthand opportunity CASE Gender WHEN...

sef.boots Grasshopper Points: 15 More actions · Answer 5

You can't answer a question of the type 'A or B? ' with TRUE or FALSE. Yet these are the only answers we can give.

Clearly illogical.

ramana3327 SSCoach Points: 19722 More actions · Answer 6

Is it possible to insert values in only one column? Actually there are two columns in table they updating only one column what will happen to second

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 7

ramana3327 (4/19/2013)
Is it possible to insert values in only one column? Actually there are two columns in table they updating only one column what will happen to second

The other column was defined using the IDENTITY property. See http://msdn.microsoft.com/en-us/library/ms186775.aspx.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 8

The question wordings were little confusing to me. But scored 1 mark.

Thanks.

Arno Kwetters Hall of Fame Points: 3881 More actions · Answer 9

Arno Kwetters

Hall of Fame

Points: 3881

June 25, 2015 at 12:43 am

#1807942

I don't get the clue. Is it so easy ?

Update with CASE statement

Cookies on SQLServerCentral