>>>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.
Cool. For some reason I never knew you could string commands like that in one SPT. Thanks!
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.