Collections:
Using User Defined Functions in Expressions in SQL Server
How To Use User Defined Functions in Expressions in SQL Server Transact-SQL?
✍: FYIcenter.com
An user defined function must return a value, which can be used in any expression as long as the return value data type matches the expression.
To execute a user defined function and use its return value in an expression, you just need to enter the schema name and the function name as a value in the expression. The tutorial exercise below shows you how use a user defined function in an expression:
USE FyiCenterData; GO -- Calling a function without schema name PRINT 'Hi there, '+Welcome(); GO Msg 195, Level 15, State 10, Line 1 'Welcome' is not a recognized built-in function name. -- Calling a function with schema name PRINT 'Hi there, '+dbo.Welcome(); GO Hi there, Welcome to FYIcenter.com
⇒ sys.objects - Listing All User Defined Functions in SQL Server
⇐ "CREATE FUNCTION" - Creating User Defined Functions in SQL Server
2016-12-24, 1254🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...