ExecuteNonQuery

  • Thread starter Thread starter Nick K.
  • Start date Start date
N

Nick K.

I have a piece of code that gets a SQL Server stored procedure script from a
xsql file and creates the stored procedure using ExecuteNonQuery.

The code works fine except that it chokes if there is a "GO" or multiple sql
such as "SET QUOTED IDENTIFER OFF" or "GRANT EXECUTION ON MySP to [myuser]"

I really need this code to execute multiple scripts along with "GO". The
current program I am using was written in the .Net Framework 1.0. Are there
some enhancements to the .Net Framework 2.0 that would allow me to do this?
 
GO is used in SQL Server scripts. It's not supported by the TSQL
parser--it's simply used to break up a script into executable batches. It is
supported by OSQL, SQLCMD and the SQL Server Management Studio query tools.
To execute a script, you need to capture the string before the GO (a batch),
execute it and test the results and loop to the next batch. This was a lab
exercise in my TSQL class at MSU... It's not hard.

--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP
 
Back
Top