Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Mixed parameters and output parameters
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement