StringBuilder sb = new StringBuilder();
List<SqlParameter> parameters =new List<SqlParameter>();
方法1
sb.Append(" and s.Name LIKE @Name");
parameters.Add(new SqlParameter("@Name", "%"+Name+"%"));
方法2
sb.Append(" AND Name like N'%'+@Name+'%' ");
parameters.Add(new SqlParameter("@Name", Name));
转载于:https://www.cnblogs.com/Lulus/p/7874178.html
相关资源:数据结构—成绩单生成器