Collections:
What Are User Defined Functions in SQL Server
What Are User Defined Functions in SQL Server Transact-SQL?
✍: FYIcenter.com
A user defined function is a collection of Transact-SQL statements that stored in the SQL Server. A user defined function will return data when executed.
A user defined function works in the same way as a system function. It can be used as a scalar expression or a temporary table depending on the turning data format. A system function is provided as part of the SQL Server. But a user defined function must be created and managed by yourself.
If you are using a group of statements to calculate the same data repeatedly in different places, you should consider to create a user defined function for that group of statements.
User defined functions are also called functions.
2016-12-28, 727👍, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......