外键和联合主键

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