For SQL Server, to install all of the scripts at once, open Install-All-Scripts.sql in SSMS or Azure Data Studio, switch to the database where you want to install the procs, and run it. It will ...

Procedures can use variables, loops, and conditional statements, whereas functions cannot. Additionally, procedures and functions can be nested, whereas triggers cannot.