Enter a value in the box provided… Consider this SQL code…
Enter a value in the box provided… Consider this SQL code below. What value would be returned for the FifthValue. CREATE SEQUENCE dbo.seq_demo1 START WITH 10 INCREMENT BY 10 MINVALUE 10 MAXVALUE 30 CYCLE; SELECT NEXT VALUE FOR dbo.seq_demo1 AS FirstValue; SELECT NEXT VALUE FOR dbo.seq_demo1 AS SecondValue; SELECT NEXT VALUE FOR dbo.seq_demo1 AS ThirdValue; SELECT NEXT VALUE FOR dbo.seq_demo1 AS FourthValue; SELECT NEXT VALUE FOR dbo.seq_demo1 AS FifthValue;
Read Details