• SQL Server
• ::
• User Defined Function
• ::
• DROP FUNCTION

subject:DROP FUNCTION
syntax:DROP FUNCTION function_name
content:ใช้ลบ function ที่กำหนด
example:CREATE FUNCTION udf_ordersVat
	( @vat int )
RETURNS @ordersVat TABLE
	(
		id int,
		item_name varchar(100),
		price_vat money
	)
AS
BEGIN
	INSERT INTO @ordersVat
	SELECT a.id, b.name, ( ( b.price * ( 100 + @vat ) ) / 100 ) AS price_vat
	FROM orders a INNER JOIN product b ON a.item_id = b.id
	RETURN
END

DROP FUNCTION udf_ordersVat