count the number of deleted rows using an after-delete trigger

deleted_rows_count-trigger.sql

-- count the number of deleted rows using an after-delete trigger
-- sql server 2019
CREATE TABLE Orders (
    OrderID int IDENTITY (1, 1) NOT NULL,
    Names nchar (15) NULL,
)
GO CREATE TRIGGER Deleted ON Orders FOR DELETE AS
DECLARE @Count int
SELECT @Count = COUNT(*)
FROM DELETED IF @Count > 0 BEGIN PRINT @Count
END
GO
INSERT INTO Orders
values ('yes')
GO
DELETE FROM Orders
GO
INSERT INTO Orders
values ('yes'),
    ('yessss'),
    ('yesss'),
    ('yesss'),
    ('yesss')
GO
DELETE FROM Orders
GO DROP TRIGGER Deleted
GO DROP table Orders