CREATE FUNCTION sf_valid_cust( @CID char(16) )RETURNS bigint AS BEGIN DECLARE @re int SET @re=0 SELECT @re=count(CID)FROM 客户表 where CID=@CIDRETURN(@re) END