This is a multi-part message in MIME format.

------=_NextPart_000_0026_01C1B853.39C3E3A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

RE: [sql_language] RE: InsertD'OH!

Sorry... of course it is!  My bad... slip of the fingers...


-- Tomm
  -----Original Message-----
  From: David Cameron [mailto:dcameron@i...]
  Sent: Sunday, February 17, 2002 6:37 PM
  To: sql language
  Subject: [sql_language] RE: Insert


  Sorry to correct you Tomm but at least for SQL Server 7 and I imagine
continued to 2000:
  @@IDENTITY rather than @IDENTITY

  regards
  David Cameron
  nOw.b2b
  dcameron@i...

  -----Original Message-----
  From: Tomm Matthis [mailto:matthis@b...]
  Sent: Sunday, 17 February 2002 12:33 AM
  To: sql language
  Subject: [sql_language] RE: Insert



  Use @IDENTITY

  -- Tomm

  > -----Original Message-----
  > From: Mark Irvine [mailto:mark@m...]
  > Sent: Saturday, February 16, 2002 8:02 AM
  > To: sql language
  > Subject: [sql_language] Insert
  >
  >
  > Hi,
  >
  > I was wondering if someone could tell me if it is possible to grab the
id of
  > a record that has just been inserted.  Assume the following table
structure
  >
  > ID, uniqueid
  > Name, varchar
  > Value, varchar
  >
  > Assuming I inserted a new record, could I grab the ID that was assigned
to
  > it by the database?
  >
  > Mark
  >
  >
  >
  > $subst('Email.Unsub').
  >



$subst('Email.Unsub').

$subst('Email.Unsub').