This is a discussion on After Triggers within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Thank you for the help. I want to create a database that will trigger reports from the MailProcessingEquip. Please ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Thank you for the help. I want to create a database that will trigger reports from the MailProcessingEquip. Please verify my code and let me know. CREATE TRIGGERS Reports_Completed ON MailProcessingEquip FOR INSERT AS DECLARE @newReport varchar(50) SELECT @newReport = (SELECT Device_Name FROM Inserted) PRINT @USPSReport + 'Report Completed' Thank you Cristian Vitan |