sql 执行报错，why？帮我改改，谢谢

2003-11-25 04:49:22 107 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【流复制环境PostgreSQL-14.1到PostgreSQL-16.1大版本升级】 PostgreSQL大版本会定期添加新特性，这些新特性通常会改变系统表的布局，但内部数据存储格式很少改变。pg_upgrade通过创建新的系统表和重用旧的用户数据文件来执行快速升级。pg_upgrade升级主要有三种用法：1、使用pg_upgrade拷贝升级。2、使用pg_upgrade链接升级（带有- -link选项），- -link较快，但是启动新版本后修改了数据文件，再启动旧版本可能数据损坏，回滚较麻烦，所以尽量避免使用link参数进行升级。阅读详情

declare cursor_basic cursor scroll for select fact_id ,used from basic_db where used=0 for update of used,fact_id
fetch next from cursor_basic into @vchfact_id

while @@fetch_status = 0
begin
...........
end

close cursor_basic

服务器: 消息 16957，级别 16，状态 4，过程 tuili，行 29
[Microsoft][ODBC SQL Server Driver][SQL Server]在 READ ONLY 游标上不能指定 FOR UPDATE。

...全文

AWR1642+DCA1000EVM 不使用mmWave Studio软件采集原始ADC数据 Timeout问题汇总 DCA1000 EVM Timeout问题汇总阅读详情

yanjianhong

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

shuiniu 2003-11-25

打赏
举报

-- =============================================
-- Declare a SCROLL cursor and use various FETCH options
-- =============================================
DECLARE <cursor_name, sysname, test_cursor> SCROLL CURSOR FOR
<select_statement, , SELECT * FROM pubs.dbo.authors>

OPEN <cursor_name, sysname, test_cursor>

-- Fetch the first row in the cursor.
FETCH FIRST FROM <cursor_name, sysname, test_cursor>

-- Fetch the last row in the cursor.
FETCH LAST FROM <cursor_name, sysname, test_cursor>

-- Fetch the row immediately prior to the current row in the cursor.
FETCH PRIOR FROM <cursor_name, sysname, test_cursor>

-- Fetch the row immediately after the current row in the cursor.
FETCH NEXT FROM <cursor_name, sysname, test_cursor>

-- Fetch the nth row in the cursor.
FETCH ABSOLUTE <row_number, int, 8> FROM <cursor_name, sysname, test_cursor>

-- Fetch the row that is n rows before or after the current row.
FETCH RELATIVE <-/+ row_number, int, -2> FROM <cursor_name, sysname, test_cursor>

CLOSE <cursor_name, sysname, test_cursor>
DEALLOCATE <cursor_name, sysname, test_cursor>
GO

yanjianhong 2003-11-25

打赏
举报

pengdali(大力 V3.0) :
谢谢，我想用滚动游标

pengdali 2003-11-25

打赏
举报

declare cursor_basic cursor for
select fact_id ,used from basic_db where used=0 for update of used,fact_id

fetch next from cursor_basic into @vchfact_id

while @@fetch_status = 0
begin
...........
end

close cursor_basic

txlicenhe 2003-11-25

打赏
举报

SQL2000的模板：

-- =============================================
-- Declare and using an UPDATE cursor
-- =============================================
DECLARE <@variable_1, sysname, @v1> <datatype_for_variable_1, sysname, varchar(20)>,
<@variable_2, sysname, @v2> <datatype_for_variable_2, sysname, varchar(40)>

DECLARE <cursor_name, sysname, test_cursor> CURSOR
FOR SELECT <column_1, sysname, au_fname>, <column_2, sysname, au_lname> FROM <table_name, sysname, pubs.dbo.authors>
FOR UPDATE of <column_1, sysname, au_fname>

DECLARE @count smallint
SELECT @count = 1

OPEN <cursor_name, sysname, test_cursor>
FETCH NEXT FROM <cursor_name, sysname, test_cursor> INTO <@variable_1, sysname, @v1>, <@variable_2, sysname, @v2>

WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
-- PRINT 'add user-defined code here...'
-- eg
PRINT 'updating record of ' + @v1 + ' ' + @v2
UPDATE pubs.dbo.authors
SET au_fname = @v1 + '-' + CAST(@count AS varchar(4))
WHERE au_lname = @v2
END
FETCH NEXT FROM <cursor_name, sysname, test_cursor> INTO <@variable_1, sysname, @v1>, <@variable_2, sysname, @v2>
SELECT @count = @count + 1
END

CLOSE <cursor_name, sysname, test_cursor>
DEALLOCATE <cursor_name, sysname, test_cursor>
GO

sql 执行报错，why？ 帮我改改，谢谢

相关推荐

sql 执行报错，why？帮我改改，谢谢