Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing Parameters To SQL Server
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01379682
Message ID:
01379688
Views:
17
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform