Posted By

systemergon on 02/12/16


Tagged

sql server Tabla tablock bloqueo


Versions (?)

Insert bloqueando la tabla


 / Published in: SQL
 

Insertar registros bloqueando mientras se realiza el proceso.

  1. INSERT INTO INTImportaExcel WITH (TABLOCK)
  2. (
  3. CV_INVENTARIO,
  4. DES_ACTIVO,
  5. MARCA,
  6. MODELO,
  7. SERIE,
  8. CS_JUR,
  9. CS_CUUM
  10. )
  11. SELECT
  12. CV_INVENTARIO,
  13. DES_ACTIVO,
  14. MARCA,
  15. MODELO,
  16. SERIE,
  17. CS_JUR,
  18. CS_CUUM
  19. FROM INTInventario
  20. WHERE INTInventario.CS_JUR=215

Report this snippet  

You need to login to post a comment.