Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Convert to EXECUTE IMMEDIATE
Sun, Sep 18 2011 3:09 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I'm just going through the conversion of a nice tested piece of SQL to an EXECUTE IMMEDIATE and I thought wouldn't it be nice to have a button to click to do it all for me, convert the sql into a string with quotes doubled up as necessary using + when I've used several lines for clarity.

Knowing how lazy Tim thinks I am I'm prepared to type the EXECUTE IMMEDIATE myself Smiley


Roy Lambert
Mon, Sep 19 2011 12:37 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I'm just going through the conversion of a nice tested piece of SQL to an
EXECUTE IMMEDIATE and I thought wouldn't it be nice to have a button to
click to do it all for me, convert the sql into a string with quotes doubled
up as necessary using + when I've used several lines for clarity. >>

Just pop it in a new SQL script window (overwrite everything), and then
select Script/Convert Into Script.  That should do it for you.

--
Tim Young
Elevate Software
www.elevatesoft.com
Mon, Sep 19 2011 1:27 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>Just pop it in a new SQL script window (overwrite everything), and then
>select Script/Convert Into Script. That should do it for you.

How long have I been blind to that?

Roy Lambert
Image