sqlserverµÄsqlÓï¾älike´ø²ÎÊýµÄÎÊÌâ

likeºóÃæÓÃÁ˲ÎÊý£¬µ«ÊDzéѯ³öÀ´µÄ½á¹ûΪ¿Õ¡£
ÎÒÓô¿sqlÓï¾äÊÇ¿ÉÒԲ鵽µÄ¡£
ÇëÎÊlikeºóÃæÓòÎÊýÊDz»ÊÇÓÐʲôÌØÊâÖ®´¦¡£
ÎÒµÄsqlÓï¾äÈçÏ£ºSQL code:

cmd = conn.CreateCommand();
string sql = @"select *
from table_a
where FlowNo like '@date%'";
cmd.CommandText = sql;
cmd.Parameters.Add(new SqlParameter("date", date));

---

C# code:
string sql = @"select *
from table_a
where FlowNo like @date";
cmd.CommandText = sql;
cmd.Parameters.Add(new SqlParameter("@date", date+"%"));

---

ÒýÓÃ

C# codestring sql=@"select *
from table_a
where FlowNo like @date";
cmd.CommandText= sql;
cmd.Parameters.Add(new SqlParameter("@date", date+"%"));

´óʦ okÁË »¹²»Ë¯¾õ°¡
ÎÒÕâ±ßÏÂÑ©ÁË Ëµ²»³öµÄ×Ìζ

---

SQL code:

select * from table_a where FlowNo like @date+'%'