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
List the different normalization forms?
what is a self join? : Sql server database administration
What is snapshot parameter in ssrs?
Can we call stored procedure in trigger?
What is a transact-sql statement batch in ms sql server?
What are commit and rollback in sql?
What is table-valued sub query?
What is the difference between a clustered index and a non-clustered index?
Explain various On-Delete options in a DB table. Which is the default option?
What is ms sql server reporting services?
How to check status of stored procedure in sql server?
How to manipulate data from one table to another table ?
What is buffer cash and log cache in sql server?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
