Advanced Search

Insert bloqueando la tabla

/ Published in: SQL
Save to your folder(s)
Insertar registros bloqueando mientras se realiza el proceso.

Expand | Embed | Plain Text

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.