What are the advantages of SQL script?

1.	What are the advantages of SQL script?
Answer» SQL scripts are easier to use because they can be SAVED and loaded whenever it is needed. It reduces the number of errors as there are no manually entered commands that are prone to human errors. We can schedule the SQL script to run at a convenient time, or when a human is not present. For holding the interim RESULT, a LOCAL VARIABLE can be DECLARED in a SQL script. SQL Script Procedure can return more than one result with the help of the “OUTPUT Parameter”, while the Normal SQL Procedure can return only one result. You are permitted to define local or global tables types that can be used as parameters in a SQL script.

Discussion