select syohinCD
from ( select syohinCD,ROWNUM as line
from ( select syohinCD from syohinTable
where syohinCD LIKE @syohinCD)
where ROWNUM<=@ROWNUM)
有问题在存储过程中用select 字段名 into 变量 from 表名
from ( select syohinCD,ROWNUM as line
from ( select syohinCD from syohinTable
where syohinCD LIKE @syohinCD)
where ROWNUM<=@ROWNUM)
有问题在存储过程中用select 字段名 into 变量 from 表名
必须把select的内容付给变量
sql server里面,这样的查询语句会返回结果集
oracle中,返回结果集需要用ref cursor来实现.