如何在SQL Server触发器中测试多行操作？

CREATE TRIGGER trg_TestMultiRowOperation
ON YourTable
AFTER INSERT, UPDATE, DELETE
AS
BEGIN
    -- Test for INSERT operation
    IF EXISTS(SELECT * FROM INSERTED)
    BEGIN
        PRINT 'Insert operation detected'
        -- Perform multi-row insert operation-related tasks here
    END

    -- Test for UPDATE operation
    IF EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED)
    BEGIN
        PRINT 'Update operation detected'
        -- Perform multi-row update operation-related tasks here
    END

    -- Test for DELETE operation
    IF EXISTS(SELECT * FROM DELETED) AND NOT EXISTS(SELECT * FROM INSERTED)
    BEGIN
        PRINT 'Delete operation detected'
        -- Perform multi-row delete operation-related tasks here
    END
END