SQL SERVER CASE PUZZLE QUERY

What would be the output of following query? 😄
SELECT CASE WHEN 1=1 THEN 'Vikas Ahlawat1'
            WHEN 2=2 THEN 'Vikas Ahlawat2'

            ELSE  'Vikas Ahlawat3' END AS Name

Ans:

You may like these posts

Post a Comment

4 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.
  1. abhi6 January 2017 at 10:48

    interesting..

    ReplyDelete
    Replies
    1. Vikas11 January 2017 at 03:34

      Thanks
      for more such questions you can follow this link http://www.interviewquestionspdf.com/2014/12/sql-server-interview-questions-and.html

      Delete
  2. SEDHU27 March 2017 at 06:10

    CAN U PLEASE EXPLAIN...........

    ReplyDelete
  3. Unknown27 November 2017 at 10:23

    case is just as switch.. when first case is true then it get terminated from that point only.

    ReplyDelete