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

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

608


What are the 3 types of schema?

606


What functions can a view be used to performed?

630


What is the difference between an index and a unique index?

556


Name 3 ways to get an accurate count of the number of records in a table?

582






What are views in ms sql server?

607


What is function of CUBE ?

616


What are transactions and its controls?

623


How to use linked server?

604


What is the concept of optimization?

580


When does a workload on SQL Azure get throttled?

113


What are sparse columns?

588


What does null mean?

609


Explain few examples of RDBMS?

619


How to insert stored procedure result into temporary table?

595