passing an XML variable from one SP to Another

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi ,
I am trying to pass value from one Sp to another SP USING A Local variable.

SQL

create proc pp
as
declare @aa xml
begin
set @aa= select phone no from table1;
exec stordproc2(@aa)
end

But it is not working. The nested SP is not accepting it. Can you plz tell why ?

Advance Thanks For reply.

Posted 15-Dec-10 0:49am

shikhar gilhotra

Updated 15-Dec-10 0:51am

Abdul Quader Mamun

v2

Add a Solution

Comments

Abdul Quader Mamun 15-Dec-10 6:51am

Decorate question & spelling check.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abdul Quader Mamun · Accepted Answer · 2010-12-15T00:55:00

Solution 1

Thank you for your question.

SQL

create proc pp
as
  declare @aa xml
begin
  set @aa= select phone no from table1;
  SELECT @aa=[phone no] AS PhoneNo FROM table1;
  EXEC stordproc2(@aa)
end

Thanks,
Mamun

Posted 15-Dec-10 0:55am

Abdul Quader Mamun

Comments

shikhar gilhotra 15-Dec-10 7:09am

thx mamun
it worked but can u tell why did u put phone no in brackets [].

Regards.

Abdul Quader Mamun 15-Dec-10 7:14am

[] bracket is used for fields name others in which space available between name. In your case Phone no. SQL does not read it because space. So for [phone no] has used. Better to not used space.

Thanks!

fjdiewornncalwe 25-Dec-10 18:30pm

Bang on...
Shikhar: I would encourage you to do this for all field names in your queries. If you get into a habit of writing queries using the square brackets around names, you will automatically not have issues and bugs introduced into code you write because of the space in names, etc.