Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trigger is locking up record
Message
 
 
À
30/04/2004 13:20:18
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00899034
Message ID:
00899851
Vues:
22
>I rewrote the Trigger as:
>
>CREATE TRIGGER [testing] ON [dbo].[Table1]
>FOR INSERT, UPDATE
>AS
>
>insert into Table2 (TT2D1) SELECT T1.TT1D1 From inserted I Inner Join Table1 T1 on T1.TT1ID = I.TT1ID
>
>
>
>Table1 continues to hang up with this trigger.

What SQL statement do you issue that it hangs on? What's purpouse of 'Inner Join' in the INSERT INTO command?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform