With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
CREATE TRIGGER Food.AlertRequest ON Food.RequestMaster AFTER INSERT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here @squery = SELECT * from RequestMaster EXEC msdb.dbo.sp_send_dbmail @profile_name = DBMail, @recipients = 'firstname.lastname@example.org', @query = @squery, @subject = @message, @attach_query_result_as_file = 1 ; END GO
|SQL Server: SNAPSHOT replication to include a newly added table.||2||29|
|Will it be possible to allow a user to mail to only a designated staff.||6||72|
|SQL query with cast||38||53|
|date diff with Fiscal Calendar||4||54|