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
What is coalesce in sql server?
Is INSTEAD OF trigger directly applicable to Table ?
How to use column default values in insert statements in ms sql server?
What is #temp and @table variable in SQL server?
How to set a database state to offline in ms sql server?
How many types of cursor type are there?
What do you mean by sql server agent?
What are data regions?
What happens if null values are involved in boolean operations?
Explain the properties of subqueries in sql server?
How to drop an existing table with "drop table" statements in ms sql server?
Explain Normalization and DE normalization
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What do you know about system database? : SQL Server Architecture
How do I create a stored procedure in sql server?
