Difference between Script, Stored Procedure, T-SQL, PL/SQL
sql, stored-procedures
Solution
Here's some rough definitions to explain the differences.
- PL/SQL - a SQL variation specific to Oracle databases.
- T-SQL (Transact-SQL) - a SQL variation specific to Microsoft (and Sybase) databases.
- Stored Procedure - a set of SQL commands that is precompiled and stored on the server for reuse
- Script - a set of SQL commands that is run ad-hoc (not precompiled / not meant for reuse)
There are more differences between Stored Procedures and Scripts (e.g. sprocs can have parameters, etc.) but that's the fundamental difference.
Problem
I'm getting really confused with all these terms. I used to attend a class called PL/SQL, then when I came out to work, I came across other terms like Stored Procedure, T-SQL and even script. They all look very similar to me, but exactly what are the differences between each of them? (if any)