Hi,
If temp tables are used to pass as parameters in an n-tier application, then how is concurrency maintained. I mean, if user A modifies records of a table and those records are passed as temp tables and at the same time another user B modifies same record at the same time then which one is updated in the database. In client server we have concepts of locks, how are locks maintained in n-tier.
Thanks in advance.
If temp tables are used to pass as parameters in an n-tier application, then how is concurrency maintained. I mean, if user A modifies records of a table and those records are passed as temp tables and at the same time another user B modifies same record at the same time then which one is updated in the database. In client server we have concepts of locks, how are locks maintained in n-tier.
Thanks in advance.