www.gusucode.com > 精典源码Delphi130:顺某指纹考勤管理系统 > 精典源码Delphi130:顺某指纹考勤管理系统/11065顺某指纹考勤管理系统delphi/SP_NoMiMa/wbSP_UpdateRenYXX_KQNO.txt
/****** Object: Stored Procedure dbo.wbSP_UpdateRenYXX_KQNO Script Date: 2000-03-22 12:27:46 ******/ /****** Object: Stored Procedure dbo.wbSP_UpdateRenYXX_KQNO Script Date: 2000-02-24 11:47:59 ******/ CREATE PROCEDURE wbSP_UpdateRenYXX_KQNO @OldKQNO char(5), @NewKQNO char(5) AS begin if Exists(Select KQNO from bYGongXX where KQNO=@NewKQNO) Return (-1) -- Call self define Store Procedure to Disable All FK Exec wbSp_EnableDisableCheckOrFK 0,"b%" Update bYGongXX Set KQNO = @NewKQNO Where KQNO= @OldKQNO -- Call self define Store Procedure to enable All FK Exec wbSp_EnableDisableCheckOrFK 1,"b%" return end