What is a CLR function?
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 is a CLR function?
Rating:
A CLR function is similar to a scalar or table-valued T-SQL function that accepts parameters, makes calculations, and returns results. It is written in .NET languages such as Visual Basic .NET and Visual C# .NET. It is exposed to SQL Server 2005 as a method that is defined in a .NET assembly. Before a CLR function can be used, the assembly should be registered in SQL Server 2005. A CLR function provides better access to Web services and real-time currency conversions as opposed to a T-SQL function.
Rating:
Was this information helpful?
Other articles
- What is an ad hoc query?
- What are collation settings?
- What is index fragmentation?
- What is a restore job?
- What is a format file?