Hi all I know that when I like to write a programming logic and write the stored procedure by dragging data using ORM or something needed .
Archived procedures are executed on the server side.
This means that the amount of large processing data does not need to pass these data over a network connection.
In addition, with stored procedures, you can create complex business logic continuously.
Say, you need to update the account every time you include the transaction, and you need to include several transactions at one go.
Instead of doing it with triggers (which have been implemented using disabled record-record access in many systems), you can pass the table variable or temporary table with input and set one set inside the process -Applied SQL statement will be very efficient.