Post reply

Update with CASE statement

  • February 22, 2013 at 7:43 am

    #1590364

    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

  • February 25, 2013 at 12:54 am

    #1590707

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

  • February 25, 2013 at 10:22 am

    #1590879

    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

  • February 26, 2013 at 5:52 am

    #1591147

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

  • February 26, 2013 at 3:29 pm

    #1591329

    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.

  • April 19, 2013 at 9:57 pm

    #1608447

    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

  • April 20, 2013 at 3:13 am

    #1608459

    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/

  • June 15, 2015 at 3:53 pm

    #1805597

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

    Thanks.

  • June 25, 2015 at 12:43 am

    #1807942

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

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

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