Answer:   There are seven types of notifications: Insert, Update, Delete, Basic, Stored Procedure, Stored Procedure Notification With Signature, and Ordered Notifications. They vary in how they are structured and operate,
In contrast with Insert Notifications, Update Notifications, and Delete Notifications, Basic Notifications require that you define a buffer table, and a database trigger or other means of monitoring database changes so that changes are written into the buffer table.