Collections:
"RETURNS TABLE" - Creating Inline Table-Value Functions in SQL Server
How To Create an Inline Table-Valued Function in SQL Server Transact-SQL?
✍: FYIcenter.com
To create an inline table-valued function, you need to use the "RETURNS TABLE" clause in the "CREATE FUNCTION" statement. There should be no function body, except for a RETURN statement with a SELECT subquery:
An inline table-valued function can be viewed as a select statement with parameters, see the example showing in this tutorial exercise:
USE FyiCenterData; GO CREATE FUNCTION Top_Links(@level INT) RETURNS TABLE AS RETURN (SELECT * FROM fyi_links WHERE counts > @level); GO SELECT counts, id, url FROM Top_Links(999900) ORDER BY counts DESC; GO counts id url ----------- ----------- ----------------------------------- 999966 36470 dgqnvmy pyjqd toqcoupuxortasdtzvc 999953 12292 qebmw v qqmywe q kza wskxqns j 999943 6192 p o qisvrakk hk od 999923 79161 kvwwg g 999920 19124 prlg fzoio 999909 90930 xqmeal ikv isx y r (6 row(s) affected)
⇒ Creating Multi-Statement Table-Value Functions in SQL Server
⇐ Syntaxes of Creating Table-Valued Functions in SQL Server
2016-12-18, 1401🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...