Interested to Buy Any Domain ? << Click Here >> for more details...
What are the benefits of using stored procedures over sql
statements?
- 3 Answers
- 8447 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / yudistara
reducing network traffic..
user friendlyness..
no need to write queries every time..
sp help to improve perfrmance
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is Transparent Data Encryption?
What is blocking?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
can an order by clause be used in a creation of a view?
What is user defined stored procedures?
Can we call future method from queueable?
What is the exact numeric data type in sql?
What is mapping schema?
How to end a stored procedure properly in ms sql server?
What is an example of a foreign key?
What is difference in performance between insert top (n) into table and using top with insert?
Mention the 3 ways to get a count of the number of records in a table.
What is sql server 2000 work load governor?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what is a join and explain different types of joins? : Sql server database administration
