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.

stored procedures are bunch of SQL queries. main advantage 
of stored procedure is that it is a self compiled and 
execution speed is faster than normal query.

for e.g. 

if we write select * from tablename and if we make stored 
proc for that statement it will execute faster than normal 
query.

An Stored Procedure is basically a set of T-SQL Statement, 
it hv lot of benifits thats y we are using SPs.
Some are the advantages of Stored Procedures.
1. it reduses the Network Traffic.
2. we can execute SP inside SP.
3. it takes slower time in execution bcz its a    
preCompiled statement.
4. create once and can use multiple times.

SP r nothing but collection of SQL stments and control flow
of  language.it execute very fastly than a stand alone sql
statment because its a precompiled statement.SPs r reduce
the network traffic

Stored procedure is a set of T-Sql statements combined to 
perform a single task of multiple tasks. It do not run 
values, It performs only tasks. It reduces network traffic 
and improve the performance. It accepts the input 
parameters. It helps to ensure the integrity of the 
database.

Stored procedures are a set of control flow SQL queries. 
Main advantage of stored procedure: it is a precompiled 
statement, hence:
Some advantages of Stored Procedures are:
1. It reduces the Network Traffic.
2. We can execute standard procedure inside standard 
procedure
3. Execution faster because it’s a precompiled statement.
4. Create once and may re-use multiple times.

Stored procedures are "defined once, used many times."A 
stored procedure is written using Transact-SQL (T-SQL). T-
SQL is a subset of ANSI SQL-92 that has extensions to the 
Standard. T-SQL includes variables, conditional logic, 
loops and flow control.A stored procedure allows you to put 
code or business logic on the database server.