Multiple Create Triggers Statements 1

[psychoflea]

Hi all

Bit of a basic question, but I have multiple trigger that I want to create to different table in one statement.

Example

CREATE TRIGGER rateaud ON [dbo].[exrate]
FOR INSERT,UPDATE
AS
Begin
........
End

CREATE TRIGGER forcastaudit ON [dbo].[forecast]
FOR UPDATE
AS
begin
.........
End

However when I run this I get a syntax error on the second Create statement, how do I let sql know when the first Create statement has finished so that it can start the next one

Many Thanks

 

[Jamfool]

GO

in QA to show next batch

 

[druer]

or COMMIT TRANSACTION

create my trigger
COMMIT TRANSACTION
create my trigger
COMMIT TRANSACTION