General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Mixed parameters and output parameters
Environment versions
SQL Server:
SQL Server 2005
Hi
I'm not suire hwo I do this.
I have a stored procedure that I'm passing parameters to and I want to pass back a result.
So I have
EXEC @return_value = [dbo].[usp_Insert_Individual]
@FamilyRef = NULL,
@StatusRef = 87,
@SoundexKey = NULL,
@ExternalRef = NULL,
@Title = @hf_in_title,
@Forenames = @hf_in_forename,
@Initials = @hf_in_initial,
@Surname = @hf_in_surname,
@Honours = NULL,
@NewIndividualRef OUTPUT
but I get an error
Must pass parameter number 27 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.
So whats the best way to return the id of the new record inserted by usp_Insert_Individual.
Thnaks
Nick
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only