Answer Posted / subbu
There are three types :
Scalar
In-line and
Multi-statement functions
Scalar UDFs return a single value. They are similar to
built-in functions such as DB_NAME(), GETDATE(), or USER_ID
(), which return a single string, date, or integer
In-line UDFs return a single row or multiple rows and can
contain a single SELECT statement. Because in-line UDFs are
limited to a single SELECT, they can't contain much logic
multi-statement UDFs can contain any number of statements
that populate the table variable to be returned. Notice
that although you can use INSERT, UPDATE, and DELETE
statements against the table variable being returned, a
function cannot modify data in permanent tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is index, cluster index and nonclustered index?
What are various ways to enhance the ssrs report?
What is checkpoint process in the sql server?
What is the difference between having clause and where clause in sql server?
SQL Server Architecture ?
How many types of schemas are there?
What is encryption key?
What are the steps to insert a table?
How to create a trigger for insert only?
Explain trigger and trigger types?
Explain the types of indexes.
What is meant by Active-Passive and Active-Active clustering setup?
What is sql server schema compare? How we can compare two database schemas?
Can another user execute your local temporary stored procedures?
How to count groups returned with the group by clause in ms sql server?
