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.
Answer Posted / 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 |
Post New Answer View All Answers
What is dimension table? : sql server analysis services, ssas
How to provide default values to stored procedure parameters?
What security features are available for stored procedure?
Explain what is lock escalation?
What is the full meaning of dml?
Can you explain what is sql server english query?
Can you explain different types of joins?
What are the advantages of log shipping?
How to list all tables in the database using odbc_tables()?
How to list all field names in the result set using mssql_field_name()?
What are Spatial data types in SQL Server 2008
Why is replication required on the sql server?
How to start sql server browser service?
Is port 1433 secure?
How to receive output values from stored procedures?