我的DB Server 是 Microsoft SQL Server 2000
裏有兩個Table A, B

TableA(AField1,AField2)
TableB(BField1,BField2)

- 當update A 時會引發Table A 裏的update trigger, 之後自動update TableB 的 BField2 裏的value
- 我有個store procedure

1 CREATE PROCEDURE dbo.spUpdateVale (@Value varchar(10)) AS
2 BEGIN
3 update tableA set AField2= @Value
4 update tableB set BField2= @Value
5 END

我想在line3 update Table A 之前關閉TableA裏的trigger......應如何做? Thanks

我自已解決了是這樣

[Disble trigger]
ALTER TABLE your_table_name DISABLE TRIGGER your_trigger_name

[Enable trigger]
ALTER TABLE your_table_name ENABLE TRIGGER your_trigger_name

我的DB Server 是 Microsoft SQL Server 2000
裏有兩個Table A, B

TableA(AField1,AField2)
TableB(BField1,BField2)

- 當update A 時會引發Table A 裏的update trigger, 之後自動update TableB 的 BField2 裏的value
- 我有個store procedure

1 CREATE PROCEDURE dbo.spUpdateVale (@Value varchar(10)) AS
2 BEGIN
3 update tableA set AField2= @Value
4
5 update tableB set BField2= @Value
6 END

我想在line3 update Table A 之前關閉TableA裏的trigger......應如何做? Thanks
==========================================================================

寫成這樣:
1 CREATE PROCEDURE dbo.spUpdateVale (@Value varchar(10)) AS
2 BEGIN
3 ALTER TABLE TableA DISABLE TRIGGER tableA_trigger1
4 update tableA set AField2= @Value
5 ALTER TABLE TableA ENABLE TRIGGER tableA_trigger1
6
7 update tableB set BField2= @Value
8 END