郑维勇的博客

                           函数(多语句表值型函数)
create function show_ginfo
(
@id int
)
returns @returntable table(商品名称 varchar(20),售价 float,备注 varchar(20))
as
begin
    declare @goods_name varchar(20),@price float
    declare @i int
    set @i=(select count(*) from tb_ware14 where 编号=@id)
    if @i>0
        insert into @returntable(商品名称,售价) select 商品名称,售价 from tb_ware14 where 编号=@id
    else
        insert into @returntable(备注) values('没有该商品信息')
   return
end