by Eric Sabi » Thu, 14 Feb 2002 22:02:35
I have a SP that scrolls through databases via a cursor. Because the
database name changes, I need to place the statement in an EXEC()
statement rather than leave it outside. But, I also want to store a
variable with a result in the statement. See below:
changes
yada..'
have it execute too?
Eric
by Steve Kas » Thu, 14 Feb 2002 23:07:26
Here is an example of how to use sp_executesql with an output
parameter:
Steve Kass
Drew University
> I have a SP that scrolls through databases via a cursor. Because the
> database name changes, I need to place the statement in an EXEC()
> statement rather than leave it outside. But, I also want to store a
> variable with a result in the statement. See below:
> changes
> yada..'
> If I tried running this, I would get "Must declare the variable
> have it execute too?
> Eric
by Dinesh T » Thu, 14 Feb 2002 23:51:24
Refer
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q262499&ID=KB...
q262499
Dinesh.
> I have a SP that scrolls through databases via a cursor. Because the
> database name changes, I need to place the statement in an EXEC()
> statement rather than leave it outside. But, I also want to store a
> variable with a result in the statement. See below:
> changes
> yada..'
> If I tried running this, I would get "Must declare the variable
> have it execute too?
> Eric
by Eric Sabin » Fri, 15 Feb 2002 11:14:59
Eric
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q262499&ID=KB...Quote:> Eric,
> Refer
> Dinesh.
> > Is this possible?
> > I have a SP that scrolls through databases via a cursor. Because the
> > database name changes, I need to place the statement in an EXEC()
> > statement rather than leave it outside. But, I also want to store a
> > variable with a result in the statement. See below:
> > changes
> > yada..'
> > If I tried running this, I would get "Must declare the variable
> > have it execute too?
> > Eric
1. Running an EXEC statement in a case statement
I have the following case statement:
CASE
END AS AuthorName,
But I get an error message. Is this a valid statement?
Khurram Chaudhary
Jentra Computers
2. Informix Job Openings Mail List
3. Using EXEC statement inside a CURSOR statement
5. How to exec a proc in a select statement
6. I have question about SQL query
7. An INSERT/EXEC statement cannot be nested
8. how to get a value from an EXEC (@SQL) statement
9. An INSERT EXEC statement cannot be nested.
10. SQl Server ignores EXEC statement
11. EXEC statement
12. Nested INSERT/EXEC statements