Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Using XML data as parameter

Author  Topic 

wkm1925
Posting Yak Master

207 Posts

Posted - 2010-03-03 : 01:31:25
Hi,

I heard using XML data as parameter will hurt the performance of T-SQL?

Some of them said, avoid the xml ! it needs to be converted in a sql usable format every time you use it.

For me, using XML data as parameter, will eliminate looping at business-tier.

Really need technical explanation.
   

- Advertisement -