Advantages of Stored Procedures

A stored procedure is simply a compiled database object that contains one or more T-SQL statements. Although SQL Server has many system-provided stored procedures, you can create your own. Creating your own stored procedures offers several advantages. Click Here to read them