Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to perform backup for certificates in sql server? : sql server security
What are cursors in ms sql server?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Explain the difference between HTTP and HTTPS in database?
Describe the functionalities that views support.
How to use "begin ... End" statement structures in ms sql server?
What are the steps to follow to configure SQL*Net?
How many types of the database links?
How will you optimize a stored procedure optimization?
How can you know if the row fetched from cursor is still valid in underlying table?
How and why use sql server?
What are the different types of replication are there in sql server 2000?
how many triggers you can have on a table? : Sql server database administration
Does index speed up select statements?
Can I delete event logs?
