Prev: how to return previous week from calender table
Next: sql server deadlock (keylock)
From: John Bell on 1 Mar 2010 17:13
On Mon, 1 Mar 2010 12:22:01 -0800, Sam <Sam(a)discussions.microsoft.com>
wrote:

>Scott,
>
>Got it. Need to use OUTPUT parameters. Thanks again for your help.

Output parameters will help would be my preferred way to return values
especially as it is a GUID, but for a return value you syntax is wrong
as Scott has tried to point out:

DECLARE @UserID uniqueidentifier
EXEC @UserID = spNewUserEntry @FirstName = 'John', @LastName = 'Smith'

If your parameter is @userIdentifier

DECLARE @UserID uniqueidentifier
EXEC spNewUserEntry @FirstName = 'John', @LastName = 'Smith',
@userIdentifier=(a)UserID OUTPUT

John
First  |  Prev  | 
Pages: 1 2
Prev: how to return previous week from calender table
Next: sql server deadlock (keylock)