About Stored Procedures

You can group Transact-SQL statements together into a series known as a stored procedure. Because a stored procedure is compiled the first time it is run, it runs faster in subsequent executions. In fact, after a stored procedure's first use (and compilation) it should run faster than a standard batch of Transact-SQL statements, even if the batch contains the exact same statements.