Link to home
Start Free TrialLog in
Avatar of Mr_Shaw
Mr_Shaw

asked on

int sql autonumber

I am using the following datatyoe to create an auto number feature in my table

numeric (18,0)

I have been trying to do the same using

int (18,0) but it does not work.
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Shaw
Mr_Shaw

ASKER

The datatype identity and numeric(18,0) is the default
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Shaw

ASKER

oh all makes sense now !
Avatar of Mr_Shaw

ASKER

thanks