Sql Server参数化查询之where in和like实现详解(三)
中拼接 % www.2cto.com
comm.CommandText = "select * from Users(nolock) where UserName like @UserName+'%'";
comm.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 200) { Value = "rabbit%" });
comm.ExecuteNonQuery();
}
本文出自 http://www.cnblogs.com/lzrabbit/archive/2012/04/22/2465313.
html