????like?????????

????like??????????????????д????????л???SQL?????????????????Ч???????????????????

using (SqlConnection conn = new SqlConnection(connectionString))
{
  conn.Open();
  SqlCommand comm = new SqlCommand();
  comm.Connection = conn;
  //?? % д?????????
  comm.CommandText = "select * from Users(nolock) where UserName like @UserName";
  comm.Parameters.Add(new SqlParameter("@UserName"?? SqlDbType.VarChar?? 200) { Value = "rabbit%" });
  comm.ExecuteNonQuery();
}
using (SqlConnection conn = new SqlConnection(connectionString))
{
  conn.Open();
  SqlCommand comm = new SqlCommand();
  comm.Connection = conn;
  //SQL????? %
  comm.CommandText = "select * from Users(nolock) where UserName like @UserName+'%'";
  comm.Parameters.Add(new SqlParameter("@UserName"?? SqlDbType.VarChar?? 200) { Value = "rabbit%" });
  comm.ExecuteNonQuery();
}

???????д????????????????????