February 7, 2005 at 1:07 pm
February 7, 2005 at 3:30 pm
To my knowledge you should not have any problems. I would suggest you put the SQL code into a stored procedure (obviously) and as long as you have your begin tran and commit tran statements in place you should be fine.
If the phone doesn't ring...It's me.
February 7, 2005 at 4:39 pm
SQL should indeed be able to handle sorting out generating the identities in this scenario. What you should be aware of is the different methods of returning the generated identity to the client. Check Books Online and make sure you understand the SCOPE_IDENTITY(), @@IDENTITY and IDENT_CURRENT().
--------------------
Colt 45 - the original point and click interface
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy