1. Some Facts about Store Procedure If a repetitive T-SQL task has to be executed within an application, then the best repository for it is a program called a Stored procedure, stored in SQL Server. Storing the code inside the SQL Server object gives us