Browse By

Tag Archives: Scalar Function

SQL - UDF and Trigger

Basic SQL for Testers : UDF & Triggers

1. User Defined Functions There are two types of User-Defined functions in SQL Server and they are Scalar, and Table-Valued. 1.1 Scalar Function A Scalar user-defined function returns one of the scalar data types. Text, ntext, image and timestamp data types are not supported. These