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|
Answer / pradip jain
Become secure program from sql Injection.
|Is This Answer Correct ?||1 Yes||0 No|
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access
What is buffer cash in sql server?
How to write a script for upate the data in prod , i have 50000 row are there
What are the differences between stored procedure and view in sql server?
What are the properties of sub-query?
What do you understand by SQL*Net?
Explain identity in sql server?
How to retrieve error messages using odbc_errormsg()?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
Is it important for a database administrator to understand the operating system and file access?
What is SQL Profiler and the use of it?