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.
⇒ Differences between Functions and Stored Procedures in SQL Server
⇐ Using User Defined Functions in SQL Server Transact-SQL
2016-12-28, 1381🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...