How are Stored Procedures different from Scripts? What are the advantages of Stored Procedures?
How are Stored Procedures different from Scripts? What are the advantages of Stored Procedures?
DIFFERENCE BETWEEN STORED PROCEDURES AND SCRIPTS -
First -
The Stored Procedure is the set of the commands of SQL which is even precompiled also it is stored over the server so that it can be reused.
The Script is mainly the set of the commands of SQL which is run means not precompiled and can be reused at all.
Second -
The script is the kid of a code and the scripts are basically smaller and also it is the the standalone kind of the programs which operates without aid of the Graphical User Interface.
Third -
The Stored Procedure can be also called properly as a script.
Fourth -
The storage procedures are basically stored into SQL server but the SQL script which is templated that are stored into the file.
Step by step
Solved in 2 steps
