Newbie Spellweaver
- Joined
- Dec 23, 2008
- Messages
- 46
- Reaction score
- 29
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...
Source:
PS: this is dekaron related
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:
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