What is the basic difference between a sql and stored
procedure ?
Answers were Sorted based on User's Feedback
Answer / karthik murugan
sql is not a named block, it can be stored as sql file outside the database, when stored procedures are named block can be stored inside the database.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / thanjairajan@gmail.com
SQL is a Language. Stored procedure is transact SQL statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
How do I turn a list into a table?
What is localdb mssqllocaldb?
Can we use rowid as primary key?
What is the differnce between view and materialized view
Define tables and fields in a database
How to perform a loop through all tables in pl/sql?
how to create a primary key with out creating an index?
What is the purpose of normalization?
How do you go back in sql?
what are the different type of sql's statements ? : Sql dba
How to create a view on a table which does not exists
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)