Stored procedures are special objects
available in sql server
It
is a collection of transact sql statements that can take or return user
supplied parameters.
It s a p recompiled statements where all the preliminary parsing operations are performed and the statements are ready for execution.
Maximum size of stored procedure is 128 MB.
