How can I convert a string with control characters to one in

I have functions that let me create this string:

vbCrLf & "-- ### HEADER END ###" & vbCrLf & "BEGIN TRANSACTION" & vbCrLf & "SET IDENTITY_INSERT &#91;dbo&#93;.&#91;WidgetDescriptions_II&#93; ON " & vbCrLf & "GO" & vbCrLf & vbCrLf & vbCrLf & "Update &#91;dbo&#93;.&#91;WidgetDescriptions_II&#93; SET ShortDescription  = 'DSA_A widget' , Description  = '&lt;description xmlns=""http://www.red-gate.com/widgets/WidgetDescriptionSCHEma""&gt;" & vbCrLf & "  &lt;descriptiveText&gt;A widget&lt;/descriptiveText&gt;" & vbCrLf & "  &lt;manufacturer&gt;Acme Incorporated&lt;/manufacturer&gt;" & vbCrLf & "  &lt;countryOfOrigin&gt;United Kingdom&lt;/countryOfOrigin&gt;" & vbCrLf & "  &lt;size length=""12"" width=""5"" height=""7"" /&gt;" & vbCrLf & "&lt;/description&gt;' , Picture  = 0x717370565797219021 WHERE   WidgetID = 1   " & vbCrLf & "GO " & vbCrLf & "If @@ERROR &lt;&gt; 0 SET NOEXEC ON " & vbCrLf & "GO" & vbCrLf

But how do I get this executable SQL script from it without saving it as a file?

-- ### HEADER END ###
BEGIN TRANSACTION
SET IDENTITY_INSERT &#91;dbo&#93;.&#91;WidgetDescriptions_II&#93; ON 
GO

Update &#91;dbo&#93;.&#91;WidgetDescriptions_II&#93; SET ShortDescription  = 'DSA_A widget' , Description  = '&lt;description xmlns="http://www.red-gate.com/widgets/WidgetDescriptionSCHEma"&gt;
  &lt;descriptiveText&gt;A widget&lt;/descriptiveText&gt;
  &lt;manufacturer&gt;Acme Incorporated&lt;/manufacturer&gt;
  &lt;countryOfOrigin&gt;United Kingdom&lt;/countryOfOrigin&gt;
  &lt;size length="12" width="5" height="7" /&gt;
&lt;/description&gt;' , Picture  = 0x717370565797219021 WHERE   WidgetID = 1   
GO 
If @@ERROR &lt;&gt; 0 SET NOEXEC ON 
GO

I guess that Redgate has a converter. But can not find him.

DieterS December 15, 2016 05:05

Comments

1 comment

Hi Dieter,

This doesn't really look like a SQL Comparison SDK question. It seems to me like your script is already stored in the desired format within the string. I'm not really sure what you want to do - is it that you want to execute the script? If so then you'll probably want to use the SqlCommand class within the .NET framework. See the MSDN documentation for more info - https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand(v=vs.110).aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1

Rob C December 22, 2016 04:45

0

Add comment

Please sign in to leave a comment.

How can we help you today?

How can I convert a string with control characters to one in

Comments

Add comment