17. What is an MSSQL stored procedure, what is its essence, and why can it execute commands?

A stored procedure is a set of SQL statements designed to accomplish a specific function. These statements are pre‑compiled and stored in the database. In essence, a stored procedure is a collection of database commands organised to achieve a particular function or management task.