Programming Assemblies


In addition to the stored procedures covered in the previous chapter, SQL Server can also host a variety of other types of common language runtime (CLR) routines. These include user-defined datatypes, functions (both scalar and table-valued), aggregates, and triggers. Like CLR stored procedures, each of these types of routines can be built in Visual Studio 2005 or 2008 using C# or Visual Basic .NET (VB. NET). Also like CLR stored procedures, it’s important to consider using these routines carefully, as CLR integration is not appropriate for all situations.


Postal Code Phone Number Query Optimizer Visual Studio Query Plan 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Robert Walters 2008

Personalised recommendations