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 connect a database with sql express.?
Explain foreign key in sql server?
What is function of master database?
How to delete duplicate records based on single column from a table?
How to delete a database in ms sql server?
Explain about system stored procedure?
What are scalar functions?
What do you mean by authentication modes in sql server?
What is trace flag in sql server?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
Tell about MOM Tool(Microsoft Operator Manager)?
What is resource governor?
What are magic tables in sql server?
What is resource db in sql server?
How to list all login names on the ms sql server?
