Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.
- 3 Answers
- 6244 Views
- 247Customer, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / paras
If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar sharma
You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.
| Is This Answer Correct ? | 2 Yes | 0 No |
Write a SQL query in order to merge two different columns into single column?
How do you identify a foreign key?
What is the difference between a check constraint and a rule?
Define clusters?
What are subquery and its properties?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
what is isolation level at dead lock?
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...
What is the command dbcc checkdb used for?
State the difference between local and global temporary tables?
Can we call future method from trigger?
what is an sql server?
-
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)
