UDF
Limitations or Restriction in SQL Functions.
July 14, 2019
Function cannot be used to perform action that can modify data ex. Insert, Update & Delete.
Function cannot be used to perform action that can modify data ex. Insert, Update & Delete.
When we want to return table as a result, then we can use table valued functions. User defined Table Valued function…
User defined scalar function returns single value as a result of function. We can return any data-type value from func…
User defined Function: User defined Function in SQL server is a set of statements or block of statements. SQL S…
Functions in SQL server : Function in SQL server is a set of statements or block of statements. Function is …