This article is aimed to introduce SQL developers to the management of sql transaction with the context of json parameters and nested stored procedures. In order to reuse programmatical object in SQL server (procedures, functions), a SQL developer might need to use nested stored procedures…