Showing posts with label autoincrementpls. Show all posts
Showing posts with label autoincrementpls. Show all posts

Tuesday, March 27, 2012

Field autoincrement

hi,
Is their anybody knows how to make field in Sql Server autoincrement?
pls. help me.i assume that you want to start with a number like 1 and increment by 1 to infinity. If this is the case you are looking for the indentity function.

BOOKS ONLINE {IDENTITY (Function)}|||hi,
thanks work fine|||...but don't use the Infinity datatype. It really eats up the drive space. :)