Posted by MC on 06/01/05 17:31
look in the BOL under the 'identity'. Its a column property....
MC
<bigjmt@hotmail.com> wrote in message
news:1117635516.378966.93950@g47g2000cwa.googlegroups.com...
> Sorry to bother you guys with what I though would be an easy task. I
> have a table in my database were I would like one of the rows to
> increment a number for each row. I want the first row to start at 1000
> and keep on incrementing by 1 'till the end of the rows (about 2.7
> million rows). I though this would be a piece of cake, but I just can't
> seem to find anything like it on the internet...weird.
> Anyways, I'm just a rookie in sql, any help would be appreciated
> Thanks
> JMT
>
Navigation:
[Reply to this message]
|