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
employee table
Fff
product_sales
SQL_Joins_Intersect_Except_Union
Movies
Stored procedure ex1
SQL Directives Order of Execution
SQL Server - NULL values with IN and NOT IN (Solution)
NAMES CODE
code