Multiple SQL transactions on a network server
I am developing an application that will be used by many users in the same time (on a network). The application will use SQL Server.
I want to know if it's good to use transactions for different queries that I开发者_JAVA技巧 have. If one user start a transaction at a time and another user starts one more, will the server know whom is a random transaction? Multiple transactions at a time are supported by one single server?
Yes, SQLServer supports multiple simultaneous transactions. There would be no point in having transactions if you could not run more than one at a time.
精彩评论