狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

Create TABLE DBLoger(
    LoginName nvarchar(50),
    HostName nvarchar(50),
    EventInfo nvarchar(500),
    Parameters int,
    EventType nvarchar(100)
)

Create TRIGGER Loger ON student
FOR Insert, Update, Delete
AS
    SET NOCOUNT ON
    
    Create TABLE #T(EventType nvarchar(100),Parameters int,EventInfo nvarchar(500))
    Insert #T exec('dbcc inputbuffer(' + @@spid + ')')
    --記錄到日志表
    Insert INTO DBLoger(LoginName,HostName,EventInfo,Parameters,EventType) Select suser_sname(),host_name(),EventInfo,Parameters,EventType FROM #T