sql語句執行自定義函數,輸出值
select dbo.sctf_EF 011A _newdanhaoNo() as newNo
CREATE FUNCTION sctf_EF 011A _newdanhaoNo()
RETURNS varchar(20)
AS
BEGIN
declare @no varchar(10)
declare @num int
select @no = max( EF 011A 007 ) from EF 011A
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