Reg Stored Proc Parameter usage & performance
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I have to create stored procs for insertions and updates for a new project with lots of parameter (around 20 to 35), i wanted to know the advantange and disadvantages of the two methods below Method 1. --- the usual way Create Procedure SaveNewSettings @param1 varchar(20),@param2 varchar(20),@param3 varchar(20), @param4 varchar(20),....etc ---- insert into table values ( Method 2. -- the xml way Create Procedure SaveNewSettings @XMLParam As varchar(200) AS EXEC sp_xml_preparedocument @hDoc OUTPUT , @XMLParam --- Do the openxml stuff and update Which method of using parameters is better wrt performance and usability. Please suggest. I am using SQL Server 2000 & ASP.Net (VB.net as code behind) for my project.