Which of the following commands below are used to run a stored procedure?

Options
- EXEC MyStoredProcedure
- EXECUTE MyStoredProcedure
- RUN MyStoredProcedure
- Both a and b above

CORRECT ANSWER : Both a and b above

Discussion Board
Stored procedure

A stored procedure is used in the SQL Server with the help of the "Execute" or "Exec" Keyword. For example, if we want to execute the stored procedure "Getstudentname", then we will use the following statement.

Execute Getstudentname 1
Exec Getstudentname 1

Prajakta Pandit 03-7-2017 06:31 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲