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 the difference between a "where" clause and a "having" clause?
Does union all remove duplicates?
Explain triggers in sql?
What have included columns when we talk about sql server indexing?
Why is sql server log file full?
Define Wed Edition in SQL Azure?
What are distinctive joins find as a part of sql?
What happens if time-only values are provided as date and time literals?
Explain cursor as data base object?
What is difference between oltp and olap?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Can we take the full database backup in log shipping?
how many triggers you can have on a table? : Sql server database administration
What happens if an integer is too big for int date type?
What is a constant or literal in ms sql server?
