Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Email trigger with multiple records
If by some chance you do have a need for instantaneous notification, you can use something similar to the following in a trigger. SET @sMsg = '' SELECT @sMsg = @sMsg + 'My Data: ' + My_Field_1 + ', My Data 2: ' + My_Field_2 + CHAR(13) + CHAR(10) FROM inserted WHERE ... This would handle...- cccook
- Post #5
- Forum: Microsoft SQL Server: Programming
