Page 2 of 2 First 12
  • Jump to page:
    #16
  1. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    You do not return the output parameter, you just need to populate it. You are issuing:
    return @nextID
    ...
    This is incorrect.
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
  2. #17
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2003
    Posts
    506
    Rep Power
    12
    that was something I changed after trying it without as well, because in the example in one of the links had a return value like I did. It does the same thing after removing the return value


    this however works
    Code:
     
    
    declare @nextID integer
    Exec GetNextID2 'hockeyPlayers', @nextID output
    select @nextID
    Thanks for the help
Page 2 of 2 First 12
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo