Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [POSOProcessing] ON [dbo].[InvNum] AFTER UPDATE AS SET NOCOUNT ON; Begin If exists(select * from _btblInvoiceLines Where iInvoiceID in ( Select AutoIndex From Inserted) and fUnitpriceincl >1000) Begin RAISERROR ('Enter Price for KG',16,1) End End