The CREATE PROCEDURE command is used to create a stored procedure.A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.The following SQL creates a stored procedure named "SelectAllCustomers" that selects all records from the "Customers"...
src A string that contains an SQL command or a stored procedure name cursortyp Specifies the type of cursor to be used. One of the CursorTypeEnum values locktyp Specifies the type of lock to be used. One of the LockTypeEnum values options One or more of the CommandTypeEnum or Execute...
SQL EXEC Keyword❮ SQL Keywords ReferenceEXECThe EXEC command is used to execute a stored procedure. The following SQL executes a stored procedure named "SelectAllCustomers":Example EXEC SelectAllCustomers; ❮ SQL Keywords Reference Track your progress - it's free! Log in Sign Up ...