Created with an IDENTITY property that is set to start at 1,000,000 and decrement by 100 for every row added : IDENTITY « Sequence « SQL Server / T-SQL






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

Created with an IDENTITY property that is set to start at 1,000,000 and decrement by 100 for every row added

1> -- Created with an IDENTITY property that is set to start at 1,000,000 and decrement by 100 for every row added
2>
3> CREATE TABLE MyTable (MyID Int IDENTITY(1000000, -100) NOT NULL
4>                      ,MyDescription NVarChar(50) NOT NULL )
5> GO
1> insert mytable (mydescription) values ('a');
2> GO

(1 rows affected)
1> insert mytable (mydescription) values ('b');
2> GO

(1 rows affected)
1> insert mytable (mydescription) values ('c');
2> GO

(1 rows affected)
1> select * from mytable
2> GO
MyID        MyDescription
----------- --------------------------------------------------
    1000000 a
     999900 b
     999800 c

(3 rows affected)
1> drop table MyTable
2> 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.SQL Server does not allow explicit values to be inserted into it
5.Now you explicitly enter a value for Identity column
6.Using Identity during data insert
7.Using IDENTITY value
8.Get current IDENTITY value
9.Seed value was negative and the increment was positive
10.IDENTITY [ (seed , increment ) ]
11.IDENTITY as PRIMARY KEY