Diffrent types of function
Answer / 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 |
Can a unique index be created on a column, which contains null?
What are page splits?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 Answers Aptech, HCL, Perpetual, SAIC,
How to create dbo table in sql server?
What are the pre-defined functions in the sql server?
Explain the cursor lock types?
How to integrate the ssrs reports in application?
What is the diff between Dynamic queries and static queries
1 Answers CGG, ICS Integrated Computer Solutions,
How to send email from database?
what is diffence between replicaion and logshipping?
How we can compare two database data?
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?