可重用的SQL Server存储过程;嵌套;全局变量

I want to make some re-useable, somewhat-dynamic TSQL code that can be called within many other stored procs, but I'm struggling with how to implement this with SQL Server.I want to make some re-useable, somewhat-dynami