Results 1 to 2 of 2

Thread: @@IDENTITY

  1. #1
    Sean West Guest

    Default @@IDENTITY

    How do I return the @@IDENTITY in VB or in an ASP?

  2. #2
    Matt Wright Guest

    Default RE: @@IDENTITY

    try this in the sql...<BR><BR>CREATE Procedure InsertPublication<BR>As<BR>set nocount on<BR> Insert into Publication(PublicationName,publicationtypeid) <BR> Values(&#039Enter new name here&#039,&#039agency&#039) <BR> declare @identat int<BR> select @identat = @@identity<BR> SELECT @identat AS "Identity"<BR><BR>and then get the value in ASP by opening up a recodset with the results and going<BR><BR>mynewID = rs("Identity")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts