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
why would you call update statistics? : Sql server database administration
What is Sqlpaging in SqlServer 2005 ?
How to join two tables in a single query in ms sql server?
What is acid properties?
What is enhanced database mirroring in sql server 2008?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is compound operators?
How to test subquery results with the exists operator?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is difference statement and preparedstatement?
How to optimize stored procedures in sql server?
What is the difference between a check constraint and a rule?
How to use wildcard characters in like operations in ms sql server?
How to replace given values with null using nullif()?
What is a collation in ms sql server?
