Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing Parameters To SQL Server
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01379682
Message ID:
01379688
Vues:
18
>>I have a stored procedure with 10 params. How do I call it if I only need to pass the 8th and 9th parameters? Do I have to include placeholders for the first 7 in the EXEC statement?
>
>Try to call it with the named parameters.
>
>E.g.
>
>execute mySP @myParam7 = myValue7, @myParam8 = myValue8

That's it. Thanks!
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform