<div>
Wrap your statement in this:<br />
EXEC ('')<br />
<br />
As in:<br />
string sql = &quot;EXEC('SELECT * FROM xx WHERE yy GO\nUPDATE...')<br />
<br />
Jim<br />

</div>


Wrap your statement in this:
EXEC ('')

As in:
string sql = "EXEC('SELECT * FROM xx WHERE yy GO\nUPDATE...')

Jim


<div>
I stand corrected.<br />
<br />
Jim<br />

</div>


<div>
Thank you.. I guess I will have to do it this way
</div>


Thank you.. I guess I will have to do it this way

<div>
<div class="content wysiwyg-content">
Hello,<br />
&nbsp; I would like to execute several lines of SQL commands through the C# program. I have the complete text of the commands stored in a string s. However I can not just use:<br />
SqlCommand command = connection.CreateCommand()<wbr />;<br />
command.CommandText = s;<br />
command.ExecuteNonQuery();<wbr /><br />
since the command text contains several &quot;GO&quot; statements and these statements have to be executed in order. Hence one statement have to finish executing before the other one starts.<br />
One way is to break up s into several statements using &quot;GO&quot; as a delimeter... however that seems painful, especially since &quot;GO&quot; can be followed by &quot;\n&quot; for ex, or &quot;GO&quot; can be part of the variable name.<br />
Is there any better build in way to do this?<br />
Thank you<br />
Peter
</div>
</div>


Hello,
  I would like to execute several lines of SQL commands through the C# program. I have the complete text of the commands stored in a string s. However I can not just use:
SqlCommand command = connection.CreateCommand();
command.CommandText = s;
command.ExecuteNonQuery();
since the command text contains several "GO" statements and these statements have to be executed in order. Hence one statement have to finish executing before the other one starts.
One way is to break up s into several statements using "GO" as a delimeter... however that seems painful, especially since "GO" can be followed by "\n" for ex, or "GO" can be part of the variable name.
Is there any better build in way to do this?
Thank you
Peter

How do I execute several lines of SQL commands using C#?

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).