Say I have an UPDATE trigger on `tableA` that inserts a new record into `tableB`. 

```
CREATE TRIGGER insertIntoTableB
ON tableA
FOR UPDATE 
AS
   INSERT INTO tableB (...) VALUES (...)  
GO

```

I then run these statements sequentially. Will the second UPDATE statement (UPDATE `tableB`) work OK? (i.e. wait for the trigger on table A to fully execute)

```
UPDATE tableA
SET ...
WHERE key = 'some key'

UPDATE tableB
SET ...
WHERE key = 'newly inserted key from trigger'

```