I am trying to create a trriger.
My DB has two admin users. Only user who has a admin right can hove right to either delete or insert a record on contract table.
when they delete or insert a record on contract table, it iwll generate the modification information which is user name , contractNum, date and time.
My first question is do i need to have the modification table to store that info for that trigger or can I just generate a view?
Second question is code for that trigger will be?
My contract DDL is
create table contract(
contractNum int identity(1,1) primary key,
contractDate smalldatetime not null,
tuition money not null,
studentId char(4) not null foreign key references student (studentId),
contactId int not null foreign key references contact (contactId)