[Solved] T-SQL INSERT INTO disabling Constraints check

by


Constraint is on the table not a single statement
Kind of ugly but
Put it in a transaction and take a tablock 

begin transaction 
  ALTER TABLE branchOffice NOCHECK CONSTRAINT ALL
  insert into branchOffice with (tablock) 
  -- Re-enable the constraints on a table
  ALTER TABLE branchOffice WITH CHECK CHECK CONSTRAINT ALL
commit transation;

3

solved T-SQL INSERT INTO disabling Constraints check