学步园

该方法主要是用于多个中间以go隔开的多个语句，通常在用sql语句批量创建表或者试图或者存储过程时。具体代码如下：/// <summary><br /> /// 批量执行sql语句<br /> /// 唐军平 2009-9-17<br /> /// </summary><br /> /// <param name="sql">执行的sql语句</param><br /> public static void ExecuteSqlNoneQueryForGO(string sql)<br /> {<br /> int startIndex = 0;<br /> string str = "/r/nGO/r/n";<br /> do<br /> {<br /> int num = sql.IndexOf(str, startIndex);<br /> int length = ((num > startIndex) ? num : sql.Length) - startIndex;<br /> string cmdText = sql.Substring(startIndex, length);<br /> if (cmdText.Trim().Length > 0)<br /> {<br /> ExecuteNonQuery(cmdText);<br /> }<br /> if (num == -1)<br /> {<br /> break;<br /> }<br /> startIndex = num + str.Length;<br /> }<br /> while (startIndex < sql.Length);<br /> }