Tag: CREATE FUNCTION

Pro Members SQL Server Standard Members

Tips for using User-Defined Functions in SQL Server 2017

by

Tips for using User-Defined Functions in SQL Server 2017 Consider using user-defined table type as a parameter for user-defined function. SQL Server 2017 supports a user-defined table type that supports representing table structures for use as parameters in user-defined function. Using UDF type can simplify user-defined function’s programming and may increase UDF performance. Use TRY-CATCH logic to trap and handle...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

User-defined functions (UDFs) – Part-1

by

User-defined functions (UDFs) – Part-1 Author: Basit A. Farooq Editor’s Note: In this first of the two part article series, you’ll compare and contrast stored procedures for creating and using scalar valued functions, in-line table functions, and multi-statement table functions. You’ll learn about syntax and parameters of CREATE FUNCTION statement. User-defined functions (UDFs) are similar to system functions, except that […]

Continue Reading →