Create table VoteMaster
(
voteID int foreign key references voteMaster(voteID),--外键
voteDetailsID int not null,
voteItem varchar(20) not null,
voteNum int default 0,
primary key(voteID,voteDetailsID)--联合主键
)
//创建触发器
create trigger updateMaster
on voteDetails
for update
as
begin
update voteMaster set voteSum=voteSum+1 where voteID=(select top 1 voteID from inserted)--从表中每更新一条信息,主表相应的也要更新一条信息。
end