Use Auto Identity if you can... Saves hassle in my opinion. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Yorke Hinds > Sent: Thursday, 18 March 2004 10:45 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: New Record - SELECT @@IDENTITY > > Another question - what is the preference Auto Identity or > manual identity insert? > > > > "Yorke Hinds" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Not having used the SELECT @@IDENTITY regularly, I was wonder > if anyone can shed some light on this method of retrieve the > Record ID on INSERT. > DB: Ms SQLServer 2000 > > All comments & insight welcome! > > > > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank > email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > >
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
