SQL Server Performance Forum – Threads Archive
XML data Type
Hi, I need input on selecting input parameter variable for stored procedure. I am confuse whether to use standard approach of using one input variable as XML data type to stored procedure or use varchar or int variable as input parameter with multiple parameter. I wanted to know if in case i have to pass only five inputs to a stored procedure whether i should use input parameter as XML(passing all five in XML) or use five input parameter. Please let me know whether any overhead i need to consider when selecting input parameter as XML. Thanks and RegardsRavi K
The optimizer prefers indicidual parameters. Consider passing parmeters as XML only when you have to set multiple set of parameters, for eg, for a multi row insert. Roji. P. Thomas
http://toponewithties.blogspot.com
Hi Thomas, Thansk for your reply. Do you have any document or link which talk about pros and cons in detail. Thanks and Regards
Ravi K
]]>