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
28-02
begginer1
MS SQL Joins
nnnnn
try catch, raiserror and throw
sql jueves
Running Total
Practice
Except Insert missing
MLK Date