Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / manisha
Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
Explain the different index configurations a table can have?
How to provide column names in insert statements in ms sql server?
What is an identity column in insert statements?
What is primary key, unique key, and foreign key?
What is difference between after and before?
Can we call future method from queueable?
what is isolation level at dead lock?
How to transfer an existing table from one schema to another schema in ms sql server?
What is replace and stuff function in sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
What is the difference between count and distinct count?
What are the advantages of having an index on the sql server?
What are statistics?
Give the query of getting last two records from the table in SQL SERVER?
Explain what is lock escalation and what is its purpose?
