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.
Database interview questions and answers asked in various interviews, faqs,tutorial and articles..