SQL functionº¯ÊýʾÀý

--´´½¨functionº¯Êý
CREATE FUNCTION GetTableDetails(@qty smallint)
returns TABLE --·µ»Øtable½á¹û¼¯
as
return (select * from sales where qty=@qty)
--µ÷Óú¯Êý
SELECT * FROM dbo.GetTableDetails(20)
--ɾ³ýº¯Êý

drop FUNCTION dbo.GetTableDetails

²éѯʾÀý£º