Execute a Stored Procedure using SQLXML

Question

Post reply

Execute a Stored Procedure using SQLXML

ItzMe

Ten Centuries

Points: 1233
More actions
December 12, 2008 at 1:08 pm

#96743

Hi Guys

How to execute a stored procedure using SQLXML?

Please give some information.

Regards

ItzSam

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

Your question is unclear. Are you trying to execute a stored proc that uses SQLXML in some way? Are you trying to get a stored procedure's output as XML?

----------------------------------------------------------------------------------
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?

ItzMe Ten Centuries Points: 1233 More actions · Answer 2

ItzMe

Ten Centuries

Points: 1233

December 12, 2008 at 2:19 pm

#911918

I need to use SQL/XML to execute a stored procedure for each row of xml.

How is SQL/XML used in SSMS.

Regards

ItzSam

Lowell SSC Guru Points: 323482 More actions · Answer 3

I'm not sure what you want to do yet either;

what is in the xml? is it data ro sql commands or what?

what does your stored procedure do ?

Are you sure you need to process xml like a cursor thru a database? a lot of times, someone might think they need to do row-by-agonizing-row processing, when a set based solution is possible instead.

give us some more details so we can help;

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lowell SSC Guru Points: 323482 More actions · Answer 4

there's an XML Workshop article here [/url] on SSC that shows how to get the number of records in xml, and then loops thru the set, but it depends on your xml and what you want to do with it;

You can do it via SS Integration Services as well.....and i've always processed XML in .NET, rather than try to do it in TSQL....there's so much to the question, not sure where we can help yet.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 5

Lynn Pettis

SSC Guru

Points: 442447

December 12, 2008 at 3:00 pm

#911939

I received your email, but I'm at a lost as to what you are trying to accomplish as well. You really need to show us what you are trying to accomplish. Your descriptions to this point aren't very helpful.

ItzMe Ten Centuries Points: 1233 More actions · Answer 6

Hi Lowell

I have an xml file as source............which is called into a stored procedure.

I need to execute the stored procedure for every row of xml using sql/xml concept.

I could not find a syntax for the execution of stored procedure using sql/xml concept but I could find the syntax for select, update and insert commands using sql/xml concept.

Please Help!!!

Thanks in Advance

ItzSam