Posted by Serge Rielau on 12/02/06 14:17

Ruediger,

How is the sequence used in the app?
While it is true that sequences are divorced from tables teh majority of
usages that I know of is for one of two purposes:
* Generate unique value across the database. If that's the case I would
look at GUID.
* Generate an abstract primary key for a specific table (or many tables,
but without actual requirement for x-database uniqueness).
In that case IDENTITY columns are the way to go.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

• Next in forum: Connectivity Issues in SQL Server 2005
• Prev in forum: Re: Table Partitioning on a RAID 5 Server
• Thread view: Re: Oracle Sequence/Link 2 MS SQL SERVER 2005

[Reply to this message]