Pasted

DECLARE @ItemOld varchar(500)='TEST1'    
DECLARE @ItemNew varchar(500)='TEST2'    
 
BEGIN TRAN
 
--DROP a FK...
--ALTER TABLE [dbo].[item] DROP CONSTRAINT [FK_item_ILC_Item]
 
--<Do the update>
 
--ADD it back...
--ALTER TABLE [dbo].[item]  WITH CHECK ADD  CONSTRAINT [FK_item_ILC_Item] FOREIGN KEY([item])
--REFERENCES [dbo].[ILC_Item] ([item])
 
--ALTER TABLE [dbo].[item] CHECK CONSTRAINT [FK_item_ILC_Item]
 
;DISABLE TRIGGER poitemIup ON poItem
;DISABLE TRIGGER poitemUpdatePenultimate ON poItem
UPDATE poitem
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER poitemIup ON poItem
;ENABLE TRIGGER poitemUpdatePenultimate ON poItem
 
;DISABLE TRIGGER exc_mesgUpdatePenultimate ON exc_mesg
UPDATE exc_mesg
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER exc_mesgUpdatePenultimate ON exc_mesg
 
UPDATE poitem_all
SET item=@ItemNew
WHERE item = @ItemOld
 
;DISABLE TRIGGER itemwhseIup ON itemwhse
;DISABLE TRIGGER itemwhseUpdatePenultimate ON itemwhse
UPDATE itemwhse
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER itemwhseIup ON itemwhse
;ENABLE TRIGGER itemwhseUpdatePenultimate ON itemwhse
 
;DISABLE TRIGGER itemIup ON item
;DISABLE TRIGGER itemUpdatePenultimate ON item
UPDATE item
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER itemIup ON item
;ENABLE TRIGGER itemUpdatePenultimate ON item
 
;DISABLE TRIGGER item_glblIupReplicate ON item_glbl
;DISABLE TRIGGER item_glblUpdatePenultimate ON item_glbl
UPDATE item_glbl
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER item_glblIupReplicate ON item_glbl
;ENABLE TRIGGER item_glblUpdatePenultimate ON item_glbl
 
;DISABLE TRIGGER itemlocIup ON itemloc
;DISABLE TRIGGER itemlocUpdatePenultimate ON itemloc
UPDATE itemloc
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER itemlocIup ON itemloc
;ENABLE TRIGGER itemlocUpdatePenultimate ON itemloc
 
;DISABLE TRIGGER jobmatlIup ON jobmatl
;DISABLE TRIGGER jobmatlUpdatePenultimate ON jobmatl
UPDATE jobmatl
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER jobmatlIup ON jobmatl
;ENABLE TRIGGER jobmatlUpdatePenultimate ON jobmatl
 
UPDATE coitem_log_all
SET item=@ItemNew
WHERE item = @ItemOld
 
;DISABLE TRIGGER coitem_logUpdatePenultimate ON coitem_log
UPDATE coitem_log
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER coitem_logUpdatePenultimate ON coitem_log
 
 
;DISABLE TRIGGER jobIup ON job
;DISABLE TRIGGER jobUpdatePenultimate ON job
UPDATE job
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER jobIup ON job
;ENABLE TRIGGER jobUpdatePenultimate ON job
 
;DISABLE TRIGGER trnitemIup ON trnitem
;DISABLE TRIGGER trnitemUpdatePenultimate ON trnitem
UPDATE trnitem
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER trnitemIup ON trnitem
;ENABLE TRIGGER trnitemUpdatePenultimate ON trnitem
 
;DISABLE TRIGGER matltrackUpdatePenultimate ON matltrack
UPDATE matltrack
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER matltrackUpdatePenultimate ON matltrack
 
UPDATE matltrack_all
SET item=@ItemNew
WHERE item = @ItemOld
 
;DISABLE TRIGGER matltranIup ON matltran
;DISABLE TRIGGER matltranUpdatePenultimate ON matltran
UPDATE matltran
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER matltranIup ON matltran
;ENABLE TRIGGER matltranUpdatePenultimate ON matltran
 
UPDATE matltran_all
SET item=@ItemNew
WHERE item = @ItemOld
 
ALTER TABLE [dbo].[lot_loc] DROP  CONSTRAINT [lot_locFk3]
 
;DISABLE TRIGGER lotIup ON lot
;DISABLE TRIGGER lotUpdatePenultimate ON lot
UPDATE lot
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER lotIup ON lot
;ENABLE TRIGGER lotUpdatePenultimate ON lot
 
UPDATE lot_all
SET item=@ItemNew
WHERE item = @ItemOld
 
;DISABLE TRIGGER lot_locIup ON lot_loc
;DISABLE TRIGGER lot_locUpdatePenultimate ON lot_loc
UPDATE lot_loc
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER lot_locIup ON lot_loc
;ENABLE TRIGGER lot_locUpdatePenultimate ON lot_loc
 
UPDATE lot_loc_all
SET item=@ItemNew
WHERE item = @ItemOld
 
ALTER TABLE [dbo].[lot_loc]  WITH NOCHECK ADD  CONSTRAINT [lot_locFk3] FOREIGN KEY([item], [lot])
REFERENCES [dbo].[lot] ([item], [lot])
 
;DISABLE TRIGGER coitemIup ON coitem
;DISABLE TRIGGER coitemUpdatePenultimate ON coitem
UPDATE coitem
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER coitemIup ON coitem
;ENABLE TRIGGER coitemUpdatePenultimate ON coitem
 
;DISABLE TRIGGER preassigned_lotUpdatePenultimate ON preassigned_lot
UPDATE preassigned_lot
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER preassigned_lotUpdatePenultimate ON preassigned_lot
 
UPDATE preassigned_lot_all
SET item=@ItemNew
WHERE item = @ItemOld
 
UPDATE coitem_all
SET item=@ItemNew
WHERE item = @ItemOld
 
;DISABLE TRIGGER apsplanUpdatePenultimate ON apsplan
UPDATE apsplan
SET parent_item=@ItemNew
WHERE parent_item = @ItemOld
;ENABLE TRIGGER apsplanUpdatePenultimate ON apsplan
 
;DISABLE TRIGGER apsplandetailUpdatePenultimate ON apsplandetail
UPDATE apsplandetail
SET parent_item=@ItemNew
WHERE parent_item = @ItemOld
;ENABLE TRIGGER apsplandetailUpdatePenultimate ON apsplandetail
 
;DISABLE TRIGGER inv_itemUpdatePenultimate ON inv_item
UPDATE inv_item
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER inv_itemUpdatePenultimate ON inv_item
 
;DISABLE TRIGGER sale_sumUpdatePenultimate ON sale_sum
UPDATE sale_sum
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER sale_sumUpdatePenultimate ON sale_sum
 
;DISABLE TRIGGER RS_QCItemhIup ON RS_QCItemh
;DISABLE TRIGGER RS_QCItemhUpdatePenultimate ON RS_QCItemh
UPDATE RS_QCItemh
SET item=@ItemNew
WHERE item = @ItemOld
;ENABLE TRIGGER RS_QCItemhIup ON RS_QCItemh
;ENABLE TRIGGER RS_QCItemhUpdatePenultimate ON RS_QCItemh
 
UPDATE item_all
SET item=@ItemNew
WHERE item = @ItemOld
 
UPDATE itemwhse_all
SET item=@ItemNew
WHERE item = @ItemOld
 
UPDATE itemloc_all
SET item=@ItemNew
WHERE item = @ItemOld
 
COMMIT