select * from AC_ChinaArea where F_AreaID like '11%' order by F_AreaId desc放到Datatable结果集里面肯定是带参数的
select * from AC_ChinaArea where F_AreaID like '%'+@F_AreaId+'%' order by F_AreaId asc可是+@F_AreaId取出来的是110100,可我只想根据前面两位去判断取出来的数据 语句怎么写???
select * from AC_ChinaArea where F_AreaID like '%'+@F_AreaId+'%' order by F_AreaId asc可是+@F_AreaId取出来的是110100,可我只想根据前面两位去判断取出来的数据 语句怎么写???
select * from AC_ChinaArea where F_AreaID like ''+@F_AreaId+'%' order by F_AreaId asc
在sql里怎么做到啊 ?
string F_AreaId = "110100"; //你自己取string strSQL = "select * from AC_ChinaArea where F_AreaID like '"+F_AreaId.Substring(0,2)+"%' order by F_AreaId asc";