What is a Stored Procedure?

 Posted by Neeks on 3/31/2009 | Category: Sql Server Interview questions | Views: 4597

Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Vivekjj on: 10/5/2012 | Points: 10
Stored procedure is a group of sql statement under a common name.we can run it every time without compileing.it can used to increase performance by the sql server

Login to post response