what is th eoutput of below SQL ?
SELECT CASE NEXT VALUE FOR [dbo].[SequenceObj]
WHEN 0 THEN 10
WHEN 1 THEN 20
WHEN 2 THEN 30
ELSE NULL
END AS [SeqCondition]

 Posted by Bandi on 6/23/2015 | Category: Sql Server Interview questions | Views: 237 | Points: 40
Select from following answers:
  1. 100
  2. 200
  3. depends on NEXT VALUE of Sequence
  4. None of the above
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response