Rajan Mishra

Rajan Mishra

  • 447
  • 3.3k
  • 53.7k

Database Dynamic Parameters

Sep 25 2018 2:09 AM
Hi,
 I was wondering if we can pass only one parameter which can held any kind of parameter in databasse in xml form and there we extract and use as per requirement.
 
Thus we may have only one parameter as per procedure which can have any parameter in any quantity.
 
such as:
  1. create proc sp1 @xml text
    begin
    Declare params int;
    set params=ExtractValue('root',@xml);
    .......
    End
My question is this process is ok or have any major flaws? 

Answers (1)