Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursors
Message
 
 
À
17/06/2011 19:06:32
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01514874
Message ID:
01515038
Vues:
58
>>Yes, that's exactly what is happening. I always put both commands together
>>
>>insert into ...
>>select SCOPE_IDENTITY()
>
>But in then you wrap that inside an explicit SQL Transaction ? Or is there some way to send 2 SQL commands like that inside the same SPT so they are part of the same implicit transaction?

You're just sending as many commands as you need in one batch. They all will be part of one implicit transaction if implicit transactions are turned on.

In other words, you can do
text to lcSQL textmerge noshow
  insert into ....
  values (<<....>>, )) ;
 select scope_identity() as NewPK
endtext
and then send this text to SQL Server using SQLExec.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform