sql語句執行自定義函數

sql語句執行自定義函數，輸出值

select dbo.sctf_EF011A_newdanhaoNo() as newNo

CREATE FUNCTION  sctf_EF011A_newdanhaoNo()

RETURNS varchar(20)

AS 

BEGIN

    declare @no varchar(10)

    declare @num int

    select @no = max( EF011A007 )  from EF011A

    if @no is null

        set @no='800001'

    else       

        begin

            set @num = convert(int, @no) + 1

            set @no = right('000000' + convert(nvarchar(6), @num),6)

        end

    return(@no)

END