Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
identity
create table person(id int identity(1001,1),name varchar(20)) insert into person values('yokesh') insert into person values('rajeh') insert into person values('rajubai') insert into person values('nivikannu') delete from person where id=1001 select *from person set identity_insert person on insert into person(id,name)values(1001,'rajini') insert into person(id,name) values(1010,'kannu') select *from person set identity_insert person off delete from person select *from person dbcc checkident('person',reseed,1000) insert into person values('nivikannu') select *from person
run
|
edit
|
history
|
help
0
MyDb
subaco
Common Table Expression
t1
How to add namespace to sql generated XML output
QLSV
bc160400784
Life cycle
Create MS SQL Server CUSTOMERS Table
Sql server 2012 features list