Subject Re: Identity
Author sqlsvr
Even if you could use DDL templates, maintaining 100+ triggers just for the purpose of auto incrementing keys is not efficient.

So I'm guessing there is no other solution to this? Oh well, time to switch to oracle.

--- In, Michael Ludwig <milu71@...> wrote:
> sqlsvr schrieb am 20.12.2010 um 16:41 (-0000):
> > WOW, So I have to create a trigger for each table which adds another
> > layer of maintenance issues?
> Script kiddies and database grand viziers have been known to avoid those
> by resorting to, say, DDL templates. Not sure what category you belong
> to. :-)
> > In all other DBMS I used, you can simply declare a field as a identity
> > field and it will do the rest.
> But sometimes they don't have sequences, which come in handy when you
> need the flexibility.
> Michael