What are the various ways in which a stored procedure can be executed?

Posted on Friday 25 May 2012 by SQL Developer


A stored  procedure can be invoked or executed using the following syntax :


  1. EXEC < Procedure Name>
  2. EXECUTE <Procedure Name>
  3. <Procedure Name>
A stored procedure with the name 'USP_SAMP' can be executed using one of the following queries:

  • EXEC USP_SAMP
  • EXECUTE USP_SAMP
  • USP_SAMP 




 

This entry was posted in . Bookmark the permalink.

Leave a reply