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
- 6294 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 |
What are the differences between having and where clause.
What is the default server name for sql server?
How to write character string constants or literals in ms sql server?
How can you insert null values in a column while inserting the data?
What are commit and rollback in sql?
What is the use of placing primary key and foreign key constrains on columns.
What stored by the model? : sql server database administration
What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
How to encrypt Strored Procedure in SQL SERVER?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How to write a query with a right outer join in ms sql server?
Describe in brief authentication modes in 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)
