April 29, 2009 at 12:18 pm
April 29, 2009 at 12:32 pm
I doubt you can do exactly that, but you can definitely send XML to one, shred it into a table (dataset), do stuff to it, and return the modified XML. Will that accomplish what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 29, 2009 at 1:40 pm
April 29, 2009 at 10:26 pm
Just curious... what will this CLR Stored Procedure do?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 1, 2009 at 1:33 pm
Laerte POltronieri Junior (4/29/2009)
I use sql server 2008.I want to create a clr stored procedure and send a datatype type Table Valued Parameters to this clr.
And this clr will do what have to do and returns this table changed ..
Can i do this ?...
No, Table-Valued Parameters cannot return modifications. So I would say go with Gus's XML idea.
By the way, this is the SQL 2005 forum. There is a forum(s) specifically for SQL 2008.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 1, 2009 at 6:52 pm
I still want to know what the CLR procedure is going to do. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply