why we use stored procedure and when?

Answer 1

stored procedures are the user created function.. why we use stored procedure hmm this is the real question suppose you have a lengthy query and u have to retrieve , manipulate data using that query and u need it in every day well in this situation u can create stored procedure, using the same query, so for daily use u don't have to write whole query again and again just execute the stored procedure u have your data

Answer 2

that's just an example we use sp(stored procedure) to minimize network traffic between client and server, speed execution purpose so on main is that u don't have to write same query again and again

Answer 3

use storage procedures will help you to minimize the works. you really don't want to be writing a lot of code every time if you used storage proc.