SQLCommand ExecuteNonQuery 最大命令文本长度

在使用SQLCommand的ExecuteNonQuery方法执行SQL语句时，通常不会受到特定的文本长度限制。然而，需要注意的是，数据库系统本身可能对SQL语句长度有一些限制，这可能因数据库引擎的不同而有所不同。因此，在实际应用中，建议了解并考虑目标数据库的文档或规范，以确保SQL语句在数据库层面没有超过其支持的限制。

csharp
using System;
using System.Data.SqlClient;
class Program
{
    static void Main()
    {
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            string sqlCommandText = "INSERT INTO YourTable (ColumnName1, ColumnName2) VALUES ('Value1', 'Value2')";
            using (SqlCommand command = new SqlCommand(sqlCommandText, connection))
            {
                int rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine($"Rows Affected: {rowsAffected}");
            }
        }
    }
}

csharp
string sqlCommandTextPart1 = "INSERT INTO YourTable (ColumnName1, ColumnName2) VALUES ('Value1', 'Value2')";
string sqlCommandTextPart2 = "INSERT INTO YourTable (ColumnName1, ColumnName2) VALUES ('Value3', 'Value4')";
using (SqlCommand command1 = new SqlCommand(sqlCommandTextPart1, connection))
{
    int rowsAffected1 = command1.ExecuteNonQuery();
    Console.WriteLine($"Rows Affected (Part 1): {rowsAffected1)");
}
using (SqlCommand command2 = new SqlCommand(sqlCommandTextPart2, connection))
{
    int rowsAffected2 = command2.ExecuteNonQuery();
    Console.WriteLine($"Rows Affected (Part 2): {rowsAffected2)");
}

csharp
string sqlCommandText = "INSERT INTO YourTable (ColumnName1, ColumnName2) VALUES (@Value1, @Value2)";
using (SqlCommand command = new SqlCommand(sqlCommandText, connection))
{
    command.Parameters.AddWithValue("@Value1", "Value1");
    command.Parameters.AddWithValue("@Value2", "Value2");
    int rowsAffected = command.ExecuteNonQuery();
    Console.WriteLine($"Rows Affected: {rowsAffected}");
}