Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
DECLARE @Cost FLOAT DECLARE @sql VARCHAR(1000) DECLARE @Product CHAR(20) DECLARE @OrderNo CHAR(10) DECLARE @OrderLineNo CHAR(5) SELECT @OrderNo = [order_no]from inserted with (NOLOCK) SELECT @OrderLineNo = [order_line_no]from inserted with (NOLOCK) SELECT @Product = [product] from scheme.opdetm with (NOLOCK)where [order_no]=@OrderNo and [order_line_no]=@OrderLineNo SELECT @Cost = [cost]from inserted with (NOLOCK) SELECT @sql = 'SELECT ' + cast(i.order_no as varchar(100)) + ' OrderNo ,' + cast(i.order_line_no as varchar(100)) + ' OrderLineNo ,' + '''' + replace(d.product , '''', '''''') + ''' product ' from inserted i with (NOLOCK) JOIN scheme.opdetm d with (NOLOCK) ON i.order_no = d.order_no AND i.order_line_no = d.order_line_no IF @Cost=0 and @Product <> 'CAT001' and @Product <> 'CAT002' BEGIN EXEC msdb.dbo.sp_send_dbmail @profile_name = '1', @recipients = 'email@example.com', @subject = 'subject', @body = 'body', @query = @sql, @execute_query_database = 'demo' END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.