Answer Posted / vikas kant
User Define Functions are used to define its own T-Sql
Function which can have 0 or more input parameters and
returns a single scalar data value type or table data type.
we have three type of UDF:-
1.Scalar user defined function
2.Inline table valued Function
3.Multiple table valued function
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Which are the important points to note when multilanguage data is stored in a table?
Explain what is it unwise to create wide clustered index keys?
Explain boyce and codd normal form(bcnf)?
How extra digits are handled with numeric data type literals?
What is catalog views?
What is the difference between composite index and covering index?
Explain the flow of creating a cube? : sql server analysis services, ssas
what is the difference between openrowset and openquery?
In case you have filters in your report, when filters will be applied in cached report instance?
What is transact-sql ddl trigger?
How to create a testing table with test data in ms sql server?
List the advantages of using stored procedures?
Explain what are magic tables in sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Can a trigger be created on a view?