DMS sql programming - creating triggers tutorial 4

[@PavanUthsara]

--question 7
create trigger tr1
on Booking
for insert
as
begin
--trigger body
--INSERTED(ShowId, CustName, numTickets)
declare @sid int
declare @seats int
declare @tickets int
select @sid=showId, @tickets=numTickets from inserted;
exec @seats=remaining_seats @sid
if(@seats

[@MohiruTushanJayawardhana]

Thank you මල්ලි ❤️

[@harshasamarasinghe5877]

❤❤

[@sachithrawijesinghe4763]

🤗