可以declare cur1 CURSOR LOCAL FOR SELECT TOP 2 object_id AS ID,NAME FROM sys.tables ORDER BY ID
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' 附近有语法错误。‘’
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' 附近有语法错误,这个提示的
BEGIN DECLARE @pono NVARCHAR(100) DECLARE @itemno NVARCHAR(100) DECLARE My_Cursor CURSOR --定义游标 FOR SELECT top 99.99 percent 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
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' 附近有语法错误,这个提示的
DECLARE @pono NVARCHAR(100)
DECLARE @itemno NVARCHAR(100)
DECLARE My_Cursor CURSOR --定义游标
FOR SELECT top 99.99 percent 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
你可以看看例子,别人的FOR是没有括号的。