liunan10032113
liunan10032113
2016-03-31 02:28

.net中sql语句的问题,爆出异常

  • net
  • sql

string sql = "select * from (select t.id,row_number() over(order by id desc) as num
from table t ) b where b.num >=:start and b.num <=:end";
OracleHelper.ExecuteDataTable(sql,new OracleParameter(":start",start),
new OracleParameter(":end",end));
执行时提示“主机/赋值变量名”异常

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

3条回答

为你推荐