If we are running set of queries as part of a process, then sending or transmitting all those queries through network will increase the network traffic and it uses more bandwidth. Stored procedures internally encapsulate the entire business logic in a unit. By invoking just stored procedure name will reduce the burden on network. Also, this uses less bandwidth. This is the reason Stored procedures are more preferred in cross applications than independent queries.
Why stored procedures are preferred in cross applications?
This entry was posted in
SQL SERVER GENERAL QUESTIONS
.
Bookmark the permalink.