getidhead.sql

出租车管理企业

CREATE FUNCTION GetIdHead(@sUseage varchar(5)
)
RETURNS varchar(2)
AS
BEGIN
     /*
     * Create by limux at 2006-09-20 22:50
     */
     if @sUseage = ''
        return ''
     declare @sIdHead varchar(2)
     if exists(select * from worktable where sUseage = @sUseage)
        select @sIdHead = sIdHead from worktable where sUseage = @sUseage
     else
         select @sIdHead = ''
         
     --返回@sIdHead
     return @sIdHead
END