gusucode.com > 精典源码Delphi044：指纹考勤管理系统源码程序 > 精典源码Delphi044：指纹考勤管理系统源码程序/精典源码Delphi044：指纹考勤管理系统/顺发指纹考勤管理系统/指纹考勤系统/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