自定义函数

 

CREATE        FUNCTION  sctf_EF008A_newdanhaoNo(@ss nvarchar(10))

RETURNS varchar(20)

AS 

BEGIN

         declare @no varchar(10)

         declare @num int

         select @no = max(MD002)  from Inventory_Detail_Data where MD001=@ss

         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

 

  select   right ('00000001',6)

        dhao = MySqlBase.GetVarFromSql("select dbo.sctf_EF008A_newdanhaoNo('"+ss+"') as newNo", "newNo");

 

带参数函数

CREATE        FUNCTION  tad_things_flow_NewFno(@Thing_No as nvarchar(20))
RETURNS varchar(20)
AS 
BEGIN
 declare @no varchar(10)
 declare @num int
 select @no = max( fno )  from tad_things_flow where Thing_No =@Thing_No
 if @no is null
  set @no='001'
 else       
  begin
   set @num = convert(int, @no) +1
   set @no = right('000' + convert(nvarchar(6), @num),3)
  end
 return(@no)
END