编程无极限

[code="sql"] create proc test as begin waitfor delay '00:00:59'-- '延迟59秒执行！ ' end go exec test [/code]

create trigger TgName on tb for update as if update(recommend) begin update tb set commenddate=(getdate()) from tb inner join inserted on tb.vlistid=Inserted.vlistid end 关键在于Inserted表 触发...