Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between a sql and stored
procedure ?
- 2 Answers
- 6821 Views
- L&T, I also Faced
- E-Mail Answers
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 |
How do I find duplicates in a single column in sql?
What is the difference between a primary key and a clustered index?
How can you create an empty table from an existing table?
How many sql databases can you have on one server?
What is the difference between functions, procedures, and packages in pl/sql?
which tcp/ip port does sql server run on? : Sql dba
in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query
Can you create a table with Primary Key not as the clustered index.
What is the difference among union, minus and intersect?
what is log shipping? : Sql dba
Is pl sql a scripting language?
what is sp_pkeys? : Transact sql
-
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)
