www.gusucode.com > 精典源码Delphi130：顺某指纹考勤管理系统 > 精典源码Delphi130：顺某指纹考勤管理系统/11065顺某指纹考勤管理系统delphi/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