SQL Server触发器.需要帮忙 [英] SQL Server Trigger. Need help

问题描述

需要帮助，如何在插入，更新时创建新触发器.可以执行以下操作:

Need help how to create new trigger on insert, update. which do following :

if dbo.rooms.status = 'booked' than dbo.rooms.innum = 1 else if dbo.rooms.status = 'checkin' then dbo.rooms.innum = 2

.请帮助

推荐答案

看看下面的链接.

http://msdn.microsoft.com/en-us/library/aa258254％28v = sql.80％29.aspx [ ^ ]

http://www.sqlteam.com/article/an-introduction-to-triggers- part-i [^ ]

Have a look at below links.

http://msdn.microsoft.com/en-us/library/aa258254%28v=sql.80%29.aspx[^]

http://www.sqlteam.com/article/an-introduction-to-triggers-part-i[^]

另外两个方便的链接:

http://technet.microsoft.com/en-us/library/aa258254% 28SQL.80％29.aspx [ ^ ]
http://msdn.microsoft.com/en-us/magazine/cc164047.aspx [ ^ ]

Two more handy links:

http://technet.microsoft.com/en-us/library/aa258254%28SQL.80%29.aspx[^]
http://msdn.microsoft.com/en-us/magazine/cc164047.aspx[^]

这篇关于SQL Server触发器.需要帮忙的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！