34,594
社区成员
发帖
与我相关
我的任务
分享
BEGIN
DECLARE @pono NVARCHAR(100)
DECLARE @itemno NVARCHAR(100)
DECLARE My_Cursor CURSOR --定义游标
FOR (SELECT a.pono,a.itemno FROM popodtl a,popo b WHERE a.MFID=b.FID AND b.pono IS NOT NULL and b.pono <>'' ORDER BY b.CreateDate desc )
OPEN My_Cursor; --打开游标
FETCH NEXT FROM My_Cursor INTO @pono,@itemno; --读取第一行数据
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @provfid INT
DECLARE @cunzai INT
DECLARE @fid INT
语法检查是关键字 'ORDER' 附近有语法错误,这个提示的SELECT a.pono,a.itemno FROM popodtl a,popo b WHERE a.MFID=b.FID AND b.pono IS NOT NULL and b.pono <>'' ORDER BY b.CreateDate desc
单独运行是可以的,但是放在在数据集里提示‘’关键字 'ORDER' 附近有语法错误。‘’ declare cur1 CURSOR LOCAL FOR
SELECT TOP 2 object_id AS ID,NAME FROM sys.tables ORDER BY ID