json parameter in sql server stored procedure code example
Example: how to insert json data in sql server using stored procedure
declare @Thedata nvarchar(max)=
(SELECT * FROM adventureworks2016.person.PhoneNumbertype FOR JSON auto, INCLUDE_NULL_VALUES)
Print @TheData;