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 is a trigger in sql?
Types of cursor locks and explanation each of them ?
How global cursor can be declare with dynamic trigger ?
Is inner join faster than left join?
Why function is used in sql?
Explain the uses of a database trigger?
What can you do with pl sql?
How to run pl sql program in mysql?
what is global table
In a distributed database system, can we execute two queries simultaneously?
How do you run a query?
What is application trigger?
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)