Identity syntax in sql

Identity column in sql server

/* To explicitly supply a value for identity column*/
/*first turn on identity_insert  set  identity_insert (Table_Name) on*/
SET IDENTITY_INSERT (Table_Name) ON

/*In the insert query specify the column's list insert into table*/
INSERT INTO (Table_Name) (Identity_Column,col2,col3,...) VALUES (Identity_Value,val2,val3,...)

/* Now set the identity_insert set off*/
SET IDENTITY_INSERT (Table_Name) OFF

Identity syntax in sql

IDENTITY[(seed,increment)]
--seed is the value of the first row loaded into the table
--increment is the incremental value added to the identity value of the previous row.
--should only contain ONE identity PER TABLE

--example:
CREATE TABLE EMPLOYEE  
(  
   IID INT IDENTITY(1,1),  
   NAME [varchar](MAX) NOT NULL,  
   AGE INT NOT NULL  
)

Source: c-sharpcorner.com

Similar codes

0 vote128 views1 answer
Sql combine results from two tables
SQL
0 vote118 views1 answer
Implicit inner join table alias with id values
SQL
11 votes118 views2 answers
Oracle source code
SQL
34 votes154 views6 answers
Alter table add foreign key mysql
SQL
45 votes191 views5 answers
Grant all privileges mysql
SQL
0 vote129 views1 answer
Sql describe
SQL
5 votes123 views1 answer
Get table columns from sql
SQL
4 votes142 views2 answers
Dbms output
SQL
0 vote125 views1 answer
Database schema for mcqs type exam in sql
SQL
12 votes114 views4 answers
Mysql version
SQL