Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Sequence object -- New Feature of 2012 sql server
--Create Sequence object CREATE SEQUENCE objSequence START WITH 1 INCREMENT BY 1; --Create Employee object DECLARE @Employee TABLE ( ID int NOT NULL PRIMARY KEY, FullName nvarchar(100) NOT NULL ) --Insert values INSERT @Employee (ID, FullName) VALUES (NEXT VALUE FOR objSequence, 'Mohan'), (NEXT VALUE FOR objSequence, 'Deepak'), (NEXT VALUE FOR objSequence, 'Pavan'); --Show data SELECT * FROM @Employee
run
|
edit
|
history
|
help
0
MY SQL
1
20181CSE0068
calendar
test1
prince46
Find gaps in timesheet data between certain hours
20181CSE0041
Digital Innovation One - SQL Server _2
TUAN 8_BTTL