Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
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.
>
>
>Just a guess (since I'm useless at SQL): Put all the assingments with a @ on the right before any that do not ?
Hi Viv
thanks but its the OUTPUT parameter thats wrong. Worked ok till I added that.
Précédent
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