Results 1 to 4 of 4

Thread: @@identity not returning any value [resolved]

Threaded View

  1. May 20th, 2005, 09:55 AM #1
    thebloke
    thebloke is offline

    Thread Starter
    Hyperactive Member thebloke's Avatar
    Join Date
    May 2003
    Posts
    358

    @@identity not returning any value [resolved]

    Can any one see what's wrong with this? I'm calling it from an asp page. It's inserting the value but not returning anything in the recordset......

    Code:
    CREATE PROCEDURE spVan_Start AS

insert into tblVan_counter (q1) values (1)

select @@identity
GO
    Last edited by thebloke; May 20th, 2005 at 10:10 AM. Reason: resolved
    The Bloke
    www.blokeinthekitchen.com
    making cooking cool for blokes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width