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 |
Authentication mechanisms in Sql Server ?
Explain the uses of a database trigger?
How do I save a stored procedure?
What is rename in sql?
What is recursive stored procedure?
Can there be 2 primary keys in a table?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is scope of pl sql developer in future?
how to check the 3rd max salary from an employee table?
how to calculate expressions with sql statements? : Sql dba
What are different types of sql?
Can a view be mutating? If yes, then how?
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)