Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Sequence Generator

Author  Topic 

srireddyp1
Starting Member

2 Posts

Posted - 2006-07-13 : 10:36:32
How can I generate a Sequence in sql server 2000 ?
Any example.
Srini

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-13 : 10:39:19
See if this helps
http://blogs.msdn.com/sqlcat/archive/2006/04/10/572848.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

srireddyp1
Starting Member

2 Posts

Posted - 2006-07-13 : 11:03:40
Hi,
This is for Sql server 2005.
What about sql server 2000 ?
Any Idea ?
I am doing some bulk insertion.
thanks.
Srini
quote:
Originally posted by madhivanan

See if this helps
http://blogs.msdn.com/sqlcat/archive/2006/04/10/572848.aspx

Madhivanan

Failing to plan is Planning to fail

Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-13 : 11:05:49
Would an identity column on the table do what you want?


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -