What are user-defined functions?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are user-defined functions?
Rating:
User-defined functions are subroutines that contain one or more Transact-SQL statements. Function can be created using CREATE FUNCTION statement. You can define input parameters to provide data to the function. User-defined functions can either return a single value or table. SQL Server supports three types of functions:
- Scalar functions
- Inline table-valued functions
- Multistatement table-valued functions
Rating:
Was this information helpful?
Other articles
- Replication
- What is the Snapshot agent?
- What is a CLR function?
- What is SQL Server Profiler?
- What are collation settings?
