RE: returning autoID after insert [sql] [tip]

S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. > -Original Message- > From: Nick Slay [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 25, 2000 6:30 PM > To: [EMAIL PROTECTED] > Subject: Re: returning autoID after insert [sql] [tip] > > &

Re: returning autoID after insert [sql] [tip]

I'm a bit puzzled with this one. Why would you write a Trigger to fire after an Insert statement, when you can do it in one hit using SELECT @@IDENTITY after the INSERT Statement all in one stored procedure? CREATE PROCEDURE UserFunction_Add @FunctionId INT = 0 OUTPUT,

RE: returning autoID after insert [sql] [tip]

maybe that's just me.) -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 9:47 AM To: '[EMAIL PROTECTED]' Subject: returning autoID after insert [sql] [tip] -

returning autoID after insert [sql] [tip]

-Original Message- From: Tom Nunamaker [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 3:21 AM To: [EMAIL PROTECTED] Subject: Re: Avoiding using the MAX function In SQL server, you can do this: CREATE TRIGGER GetMax_ID ON mytable FOR INSERT AS SELECT mytable_ID FROM INSERTED