This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 我想在SQLSERVER对CURSOR进行UPDATE操作，但是系统总是返回CURSOR不可被UPDATE的信息。是不是要改其他系统设置呢？...
DECLARE CUR_ABC CURSOR KEYSET
FOR SELECT A, B, C FROM TBL
FOR UPDATE OF A
...
执行的时候就会出错说CURSOR不可UPDATE
-zhihaoxx(大陆移民甲);
2004-8-9
{125}
(#1834977@0)
-
By default the cursor is for read only. You need to declare the cursor for update explicitly.
-nexttime(11);
2004-8-9
(#1835022@0)
-
How to?
-zhihaoxx(大陆移民甲);
2004-8-9
(#1835028@0)