郑维勇的博客

    函数(标量函数)

Eg3:
create function show_price
(
@goods_name varchar(20)
)
returns float
as
begin
    declare @price float
    set @price=(select 进价 from tb_ware14 where 商品名称=@goods_name)
    return @price
end

-------------------------------------------------------------------------------------------------
Eg4:
create function goods_time
(
@id int
)
returns datetime
as
begin
   declare @goods_time datetime
   set @goods_time=(select 进货日期 from tb_ware14 where 编号=@id)
   return @goods_time
end