SQL Server Performance Forum – Threads Archive
Passing and Receiving tables To/From SP
Hi All, In MSSQL 2000, it was not possible to nest the passing and receving of resultset (table) to multiple nested levels. Is it possible in SQL Server 2005? If yes, please point me to some links confirming the same. Regards,Amit
Can you give us more information on what you are trying to do? Madhivanan Failing to plan is Planning to fail
Not sure what you’re after but have a look at SQL Server MVP Erland Sommarskogs article about passing data between stored procedures athttp://www.sommarskog.se —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
Guys, I have a partitioned database and i am accessing them through view. My queries on that view do not run (they give error) if it has more then 255 tables. Otherwise i am quite happy with the performance of my db. I just want to know if i can partition them further. Frank, The article by Erland is good but i have reservations regarding performance because of xml parsing and all. Let me see if i can find something else which is purely TSQL Madhivanan, I don’t think my question really needs explanation on what i am doing here. I just need to pass and receive recordsets. Anyways, thanks all for replying Amit
quote:
The article by Erland is good but i have reservations regarding performance because of xml parsing and all
You’re correct. I haven’t tested that myself, but I guess extensive XML parsing is likely to be not very fast.
—The article by Erland is good but i have reservations regarding performance because of xml parsing and all
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
An year back i did a comparison between passing an array of values in a string (comma separated) versus passing them as an xml. xml approach was much slower then raw approach because of XML parsing involved. Going by xml way is easy to code but definitely not faster. Amit
]]>