Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
Convert to EXECUTE IMMEDIATE |
Sun, Sep 18 2011 3:09 AM | Permanent Link |
Roy Lambert NLH Associates 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 Roy Lambert |
Mon, Sep 19 2011 12:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Roy Lambert NLH Associates 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 |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |