MS-SQL 加锁: create trigger TR_Test on A for update as begin if getdate(hh,getdate(),'21:55-00:00') and getdate(hh,getdate(),'22:55-00:00') begin raiserror('加锁数据,不允许你修改!',16,3) Rollback Tran end else commit Tran enduser1 修改前加入SQL语句 alter table a disable trigger TR_Test 用后 alter table a enable trigger TR_Test
加锁:
create trigger TR_Test on A for update
as
begin
if getdate(hh,getdate(),'21:55-00:00') and getdate(hh,getdate(),'22:55-00:00')
begin
raiserror('加锁数据,不允许你修改!',16,3)
Rollback Tran
end
else
commit Tran
enduser1
修改前加入SQL语句
alter table a disable trigger TR_Test
用后
alter table a enable trigger TR_Test