1.靈活使用@@rowcount;
2.多用數據測試;
3.寫触发器時,要考慮到多行的情況;
http://expert.csdn.net/Expert/topic/2916/2916477.xml?temp=.4814722
2.多用數據測試;
3.寫触发器時,要考慮到多行的情況;
http://expert.csdn.net/Expert/topic/2916/2916477.xml?temp=.4814722
begin tran...
另外,合理使用@@error CREATE TRIGGER TestTrig ON A FOR INSERT AS
SAVE TRANSACTION MyName
DELETE FROM B WHERE id IN (SELECT id FROM inserted)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION MyName
END
用print显示错误,笨点管用。