What is a function? Give some example?

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


Please Help Members By Posting Answers For Below Questions

How is sql used in sql server?

497


How to store and query spatial data?

558


what is database replication? : Sql server database administration

528


What is system stored procedures?

581


Mention the 3 ways to get a count of the number of records in a table.

551






what is the difference between delete table and truncate table commands? : Sql server database administration

519


How to view existing indexes on an given table using sp_help?

591


What is a matrix in ssrs?

101


What is the difference between a stored procedure and a user defined function?

541


What is policy management?

578


Why do we use stored procedures in sql server?

493


What is difference between join and natural join?

477


What is a field name?

511


What is sub query and its properties?

545


How many cores do I need for sql server 2016?

502