gusucode.com > 精典源码Delphi044：指纹考勤管理系统源码程序 > 精典源码Delphi044：指纹考勤管理系统源码程序/精典源码Delphi044：指纹考勤管理系统/顺发指纹考勤管理系统/指纹考勤系统/SP_NoMiMa/wbSp_GetTSKQBiaoJ.txt

    
/****** Object:  Stored Procedure dbo.wbSp_GetTSKQBiaoJ    Script Date: 2000-03-22 12:27:46 ******/

/****** Object:  Stored Procedure dbo.wbSp_GetTSKQBiaoJ    Script Date: 2000-02-24 11:47:59 ******/
CREATE PROCEDURE wbSp_GetTSKQBiaoJ
  @BJName char(20),
  @KQBJ Char(2) output 
AS
begin
  if Exists(Select BJCode from bTSKQBJ where BJName=@BJName)
    Set @KQBJ=(Select top 1 KQBJ from bTSKQBJ where BJName=@BJName)  
  else
    Set @KQBJ=NUll
  return
end