sp_5.sql

use tempdb
go

-- membuat functions

CREATE FUNCTION dbo.minimum(@nilai1 float, @nilai2 float)
returns float
as
begin
	declare @min float
	set @min = @nilai1
	if @nilai2 < @nilai1 
	begin
		set @min = @nilai2
	end
	return @min
end
go

-- menjalankan stored procedure dan melihat hasilnya

select SalesOrderID,SubTotal,Freight, dbo.minimum(subtotal,freight) as min_nilai from AdventureWorks2012.sales.SalesOrderHeader

-- menghapus


DROP function [dbo].[minimum]