Runnin UP_store procedure help

I asked to run and update this store procedure

Run the stored procedures using the 2016 Kids play season as a parameter. The ID for 2016 Kids play is 648

UP_Fill_TX_Play_SEATS

How do I run this store procedure using that parameter? Am I supposed to select that table then run the above store procedure?
iamuserAsked:
Who is Participating?
 
ste5anSenior DeveloperCommented:
The syntax is

[ { EXEC | EXECUTE } ]
    { 
      [ @return_status = ]
        [ [ @parameter = ] { value 
                           | @variable [ OUTPUT ] 
                           | [ DEFAULT ] 
                           }
        ]      
    }
[;]

Open in new window


So a short

EXEC UP_Fill_TX_Play_SEATS 648;

Open in new window


may work.

But you should simply use SSMS to execute it:

Untitled.png
0
 
iamuserAuthor Commented:
If you use SSMS where do you insert the parameter ?
0
 
ste5anSenior DeveloperCommented:
Have you tested it?

SSMS presents you a dialog to enter the parameter.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
iamuserAuthor Commented:
I see a value column. I assume that's the correct column
0
 
ste5anSenior DeveloperCommented:
Yup, there you can enter it.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
iamuser, do you need more help on this question?
0
 
iamuserAuthor Commented:
That was it. Thanks for the answer, sorry for the late reply
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.