What is Stored Procedure? What is the advantage of these?

Answer:

Stored Procedure means a group of T-SQL statements stored under a name and executed as a single unit of work. A stored procedure can be called from another stored procedure, from a client application.

Advantages are given below:-

Fast Execution
Network Load Reduction.
Security.