What are the steps to create a stored procedure?

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 3284

The stored procedure is created using keyword Create Proc or Create Procedure.The procedure should be paramerized along with data types.
The required logic should be inserted in begin and end block
In order to execute the stored procedure use exec

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response