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 FourthValue. CREATE SEQUENCE dbo.seq_demo1 START WITH 50 INCREMENT BY 25; SELECT NEXT VALUE FOR dbo.seq_demo1 AS FirstValue; SELECT NEXT VALUE FOR dbo.seq_demo1 AS SecondValue; ALTER SEQUENCE dbo.seq_demo1 INCREMENT BY 10; SELECT NEXT VALUE FOR dbo.seq_demo1 AS ThirdValue; SELECT NEXT VALUE FOR dbo.seq_demo1 AS FourthValue;
Read Details