TechTalkz.com Logo

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft SQL Server

Notices

Will Sql server 2008 have generators?

Microsoft SQL Server


Reply
 
Thread Tools Display Modes
Old 11-12-2007, 04:38 PM   #1
Marcello
Guest
 
Posts: n/a
Will Sql server 2008 have generators?

Hi,

I Prefer to work with generators instead of AutoInc fields.
Sql servers is the only Database I Know that does not have generators.
Does the 2008 server will have generators,like all other databases?
  Reply With Quote
Old 11-12-2007, 04:38 PM   #2
David Portas
Guest
 
Posts: n/a
Re: Will Sql server 2008 have generators?

"Marcello" <.br> wrote in message
news:...
> Hi,
>
> I Prefer to work with generators instead of AutoInc fields.
> Sql servers is the only Database I Know that does not have generators.
> Does the 2008 server will have generators,like all other databases?


I guess you mean "sequences" as in Oracle and DB2? There is no special
sequence object in SQL Server 2008 but it's easy to implement yourself. In
fact it's not much different to the method used in Oracle anyway, you just
have to create a proc to do it.



--
David Portas


  Reply With Quote
Old 11-12-2007, 04:40 PM   #3
TheSQLGuru
Guest
 
Posts: n/a
Re: Will Sql server 2008 have generators?

What, exactly, is a generator - and how does it vary from an identity field?

--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.


"Marcello" <.br> wrote in message
news:...
> Hi,
>
> I Prefer to work with generators instead of AutoInc fields.
> Sql servers is the only Database I Know that does not have generators.
> Does the 2008 server will have generators,like all other databases?



  Reply With Quote
Reply

Thread Tools
Display Modes



< Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT +5.5. The time now is 08:19 PM.


vBulletin, Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2009, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional