这样的东西：

SELECT * FROM [tbl] WHERE [id] > 6;
DELETE FROM [tbl] WHERE [id] > 6

我是trying it与sql小提琴,但如果我这样做：

SELECT * FROM [tbl]

我得到了完整的表格,好像没有删除任何内容.

编辑按照下面的要求,这里是检索记录的完整.NET代码：

string strsqlStatement = "SELECT * FROM [tbl] WHERE [id] > 6;" +
    "DELETE FROM [tbl] WHERE [id] > 6";

using (sqlCommand cmd = new sqlCommand(strsqlStatement,connectionString))
{
    using (sqlDataReader rdr = cmd.ExecuteReader())
    {
        while(rdr.Read())
        {
            //Read values
            val0 = rdr.GetInt32(0);
            val3 = rdr.GetInt32(3);
            //etc.
        }
    }
}