Insert bloqueando la tabla


/ Published in: SQL
Save to your folder(s)

Insertar registros bloqueando mientras se realiza el proceso.


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.