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 Ticketing tool used in Wipro technologies at Bangalore...???
What are the properties and different types of sub-queries?
How do I schedule a sql server profiler trace?
What is database mirroring?
Does transparent data encryption provide encryption when transmitting data across the network?
Where views are stored in sql server?
Explain active/passive and active/active cluster configurations?
What is a Join and explain its types?
How to provide default values to stored procedure parameters?
What are the source of constraints?
What are acid properties of transaction?
What are the benefits of filtered indexes?
How will you optimize a stored procedure optimization?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
