SQL Server does not allow explicit values to be inserted into it : IDENTITY « Sequence « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Sequence
  3. IDENTITY

SQL Server does not allow explicit values to be inserted into it


1> -- SQL Server does not allow explicit values to be inserted into it
2>
3> CREATE TABLE MyTable (MyID Int IDENTITY(-1000000, 100) NOT NULL
4>                       ,MyDescription NVarChar(50) NOT NULL)
5>
6>
7> INSERT MyTable (MyID, MyDescription)
8> VALUES (5, 'This will not work')
9> GO
Msg 544, Level 16, State 1, Server JAVA2S\SQLEXPRESS, Line 7
Cannot insert explicit value for identity column in table 'MyTable' when IDENTITY_INSERT is set to OFF.
1>
2> select * from MyTable
3> GO
MyID        MyDescription
----------- --------------------------------------------------

(0 rows affected)
1>
2> drop table MyTable
3> GO
1>
2>








Related examples in the same category

1.IDENTITY (1, 1)
2.Identity starting with -1000000
3.SQL Server chooses the highest number as its current seed for a positive increment value or the lowest for a negative increment value
4.Now you explicitly enter a value for Identity column
5.Using Identity during data insert
6.Using IDENTITY value
7.Get current IDENTITY value
8.Seed value was negative and the increment was positive
9.Created with an IDENTITY property that is set to start at 1,000,000 and decrement by 100 for every row added
10.IDENTITY [ (seed , increment ) ]
11.IDENTITY as PRIMARY KEY