[HOW TO] Auto increment in MSSQL Dekaron

[janvier1985]

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...

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

or

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

Source:

You must be registered to see links

PS: this is dekaron related