Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors
Message
 
 
To
17/06/2011 19:06:32
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01514874
Message ID:
01515038
Views:
57
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform