雨果

Function

SQL Server tabular function is a program that can be used to return data by joining the multiple tables. Essential standard conventions of comparing a function with the procedure are listed below;

The function is used to reckon the data from single or multiple tables and must return a result set

A function is a real-time compilation program

A function does not allow to perform any ALTER, CREATE, INSERT, UPDATE, or DELETE operation with the user table except the temp table and variable table

A function generates run time execution plan

A function does not support the OUTPUT parameter

A function cannot call the procedure inside the program’s body