摘要：
删除新闻类别时同时删除类别下的所有新闻，新闻下的所有评论alter TRIGGER trig_CategoryDelete ON category instead of DELETEAS BEGINdeclare @caid intselect @caid=id from deleted--删除评论delete comment where newsID in (select id from news where caid=@caid )--删除新闻delete news where caid=@caid--删除类别delete category where id=@caidENDGOps1:c 阅读全文
posted @ 2012-12-20 12:39
觉信
阅读(452)
评论(0)
推荐(0)
浙公网安备 33010602011771号