sql - can activate trigger when last record entered to table? -


am new triggers , have 3 tables bill table main data of bill billitem table items listed in bill billserialnb table serial numbers related items listed in bill

i need trigger compare entered billitem qty serialnmb related these billitems if serialnb not equal billitem qty should raise error , return .

the idea if trigger done after insert or update on billserialnb table , being fired on each single record entered billserialnb table , not able right counting of serial number entered , can catch whole rows enter table ?!

is there solution ?


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -