create function third_func
(
@item int)
RETURNs int
as
begin
Declare @rate int
select @rate = Im_rate*(Im_rate + 10) from Item where Im_itemcd = @item
RETURN @rate
End
----------------
select dbo.third_func(1)
(
@item int)
RETURNs int
as
begin
Declare @rate int
select @rate = Im_rate*(Im_rate + 10) from Item where Im_itemcd = @item
RETURN @rate
End
----------------
select dbo.third_func(1)
No comments:
Post a Comment