Feature Request - Assist Dynamic SQL

I need to save T-SQL scripts inside a database field to be executed by a SSIS package. This is not an uncommon thing. So, if I need to insert the script into the table and the script has single quotes, it would be nice if SQLPrompt (or a different project) could handle the multiple single quote issues with that.

Basically this:

IF EXISTS &#40;SELECT TOP 1 * FROM Lookup.Country WHERE CountryCode = '&#123;&#123;'&#41;
BEGIN
   EXEC UnitTest.RaiseValidationErrors 'UPDATEBEFORE'
END
ELSE
IF NOT EXISTS &#40;SELECT TOP 1 * FROM Lookup.Country WHERE CountryCode = '&#125;&#125;' AND CountryName = 'UPD'&#41;
BEGIN
   EXEC UnitTest.RaiseValidationErrors 'UPDATEAFTER'
   END
RETURN

Becomes this. (I added the Select so one could run it and see the script).

Select
'IF EXISTS &#40;SELECT TOP 1 * FROM Lookup.Country WHERE CountryCode = ''&#123;&#123;''&#41;
BEGIN
   EXEC UnitTest.RaiseValidationErrors ''UPDATEBEFORE''
END
ELSE
IF NOT EXISTS &#40;SELECT TOP 1 * FROM Lookup.Country WHERE CountryCode = ''&#125;&#125;'' AND CountryName = ''UPD''&#41;
BEGIN
   EXEC UnitTest.RaiseValidationErrors ''UPDATEAFTER''
   END
RETURN'

DavidStein October 02, 2012 10:46

Comments

1 comment

You can request features for this product in our uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
These forums are monitored by our developers and allow our users to request features and vote on them.
If a request recieves significant support the feature may be included in a future release.

Manfred.Castro October 03, 2012 12:53

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Feature Request - Assist Dynamic SQL

Comments

Add comment