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

No comments:

Post a Comment