February 13, 2009 at 12:34 pm
Hello friends
I've a question for yours. What data type is more recommended to use inside Stored Procedure when there are many paramenters? I work with SQL Server2005.
In my job we use data type: VARCHAR (max) because we send until 10 parameters in a SP.
How so effective the type is XML and not Varchar(max)? Is recommended XML or Varchar?
Thanks
Luis
PD: Sorry but my english is very bad. Yo hablo español, soy ecuatoriano.:)
February 13, 2009 at 3:08 pm
I'd have to say - it comes down to how you plan on using the field. In the case you seem to be describing - you're looking to pass in parameters which for some reason you are combining into a single parameter. That would hint to me yI would want XML, since it gives you a starting structure to work from, but ultimately - if you control both the input and the contents, pick the way that works best for you and roll with it.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply