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.
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 is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How to use the inserted and deleted pseudo tables?
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
What do you mean by acid?
why we use cursor?
4 Answers CarrizalSoft Technologies, Melstar, TCS,
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is transaction server explicit transaction?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What happens if null values are involved in datetime operations?
How do I find the transaction log size in sql server?
Explain the different index configurations a table can have?
i need some interview questions on sql server developer plz any onee send some links.
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)