With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!
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
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.