System.Data.SqlClient.SqlException:““GO”附近有语法错误。

Question

sb.Append("USE 98");
               sb.Append(@"IF EXISTS(SELECT * FROM sys.procedures WHERE name = '98') DROP PROCEDURE 98");
               sb.Append(@"GO ");
               sb.Append(@"CREATE PROC 98 @ID INT, @Time datetime, @Un bigint, @Data VARCHAR(50) AS BEGIN UPDATE Data20220401 SET DataFlag = @Data, ");
               sb.Append("ID =@ID WHEREId = @Id AND DATEDIFF(ss, Time, @Time) = 0 END");
               string KJil = sb.ToString();

                comStr = new SqlCommand(KJil, conStr);//SQL语句执行对象，第一个参数是要执行的语句，第二个是数据库连接对象
               
               comStr.ExecuteNonQuery();

想用c# 提交存储事务 System.Data.SqlClient.SqlException:““GO”附近有语法错误，提示这个错误，GO在语句中无法执行

Answer 1

Go需要单独执行

sb.Append("USE 98");
               sb.Append(@"IF EXISTS(SELECT * FROM sys.procedures WHERE name = '98') DROP PROCEDURE 98");
 string KJil = sb.ToString();
comStr = new SqlCommand(KJil, conStr);
comStr.ExecuteNonQuery();
comStr = new SqlCommand("Go", conStr);
comStr.ExecuteNonQuery();
sb.delete( 0, sb.length() );
sb.Append(@"CREATE PROC 98 @ID INT, @Time datetime, @Un bigint, @Data VARCHAR(50) AS BEGIN UPDATE Data20220401 SET DataFlag = @Data, ");
sb.Append("ID =@ID WHEREId = @Id AND DATEDIFF(ss, Time, @Time) = 0 END");
KJil = sb.ToString();
comStr = new SqlCommand(KJil, conStr);
comStr.ExecuteNonQuery();