HomeSQL SERVER CASE PUZZLE QUERY SQL SERVER CASE PUZZLE QUERY 4 Vikas 22:09 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: Newer Older
interesting..
ReplyDeleteThanks
Deletefor more such questions you can follow this link http://www.interviewquestionspdf.com/2014/12/sql-server-interview-questions-and.html
CAN U PLEASE EXPLAIN...........
ReplyDeletecase is just as switch.. when first case is true then it get terminated from that point only.
ReplyDelete