错误信息里说的很明白了,改一下就行了
==============================================================
declare ChangeLogCur cursor static for select * from zhang.DBTrans.dbo.TB_YX_ChangeLog order by FD_TableName,FD_RecordID,FD_OptType
==============================================================
==============================================================
declare ChangeLogCur cursor static for select * from zhang.DBTrans.dbo.TB_YX_ChangeLog order by FD_TableName,FD_RecordID,FD_OptType
==============================================================
你可以用打开一个只读游标
declare cur cursor read_only for
select name from zhang.DBTrans.dbo.sysobjects order by type,xtype或者设置事务锁定级别:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE