I want to pass the data to the Stored Procedure via Parameter from studio using execute query .But the declaration of the parameter in the Stored Procedure is in XML data type .
Declare @Id XML = NULL
Declare @Name XML = NULL
Here how can i pass the parameter id from the studio .
In which data type i have to create a variable and pass it as a parameter in Studio.
Thanks in Advance ,