What are the steps to create a stored procedure?

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

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