[HOW TO] Auto increment in MSSQL

[janvier123]

i post here becuz ive found it useful for php scripters

I need to increment a field in every addition of a new record... what is the script for the auto increment in a create statement and alter table statement...

PHP Code:

CREATE TABLE [dbo].[new_table](
[recNum] [int] IDENTITY(1,1)
)

or

ALTER TABLE [dbo].[new_table]
ADD [recNum] [int] IDENTITY(1,1) 


Source: