effect of MODIFY on temp table

Eugene
Eugene Member Posts: 309
edited 2007-12-22 in SQL Performance
MS SQL database.
Does MODIFY on temporary table set the transaction into SERIALIZABLE isolation level mode ?

Comments

  • kine
    kine Member Posts: 12,562
    It is easy to check. Do some example and use the client monitor to see what is sent to SQL...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Eugene
    Eugene Member Posts: 309
    just checked and - nope, it does stay in the previous mode.
    So one can read data into temporary tables in READ UNCOMMITED mode and process it in temporary tables.
    The question then is how to ensure data has not changed during that time ? I want something similar to native optimistic locking with version check LOCKTABLE(TRUE,TRUE)
  • bbrown
    bbrown Member Posts: 3,268
    Since the temporary table is only visible to the 1 user, why would this be a problem?
    There are no bugs - only undocumented features.

Categories