Stored procedures are precompiled T-SQL statements combined to perform a single task of several tasks. It’s basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements. As, its precompiled statement, execution of Stored procedure is comparatively high when compared to an ordinary T-SQL statement.