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
How to create percentile function?
What is a rownum?
What is server-level principal?
What are alternate keys?
what authentication modes does sql server support? : Sql server database administration
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is an execution plan? When would you use it?
How to drop an existing schema in ms sql server?
What is updatable resultset?
What is difference between inner join and full join?
Does transparent data encryption provide encryption when transmitting data across the network?
write an SQL query to list the employees who joined in the month of January?
What is the difference between dropping a database and taking a database offline?
Why we use functions in sql server?
What are the approximate numeric data types?