Training
Module
Create stored procedures and user-defined functions - Training
This content is a part of Create stored procedures and user-defined functions.
CLR Stored Procedures
Stored procedures are routines that cannot be used in scalar expressions. They can return tabular results and messages to the client, invoke data definition language (DDL) and data manipulation language (DML) statements, and return output parameters.
Note
Microsoft Visual Basic does not support output parameters in the same way that Microsoft Visual C# does. You must specify to pass the parameter by reference and apply the <Out()> attribute to represent an output parameter, as in the following:
VB
Public Shared Sub ExecuteToClient( <Out()> ByRef number As Integer)
For more detailed information, see the version of SQL Server documentation for the version of SQL Server you're using.
SQL Server documentation
Additional resources
Documentation
-
Use Common Language Runtime (CLR) Integration to Build Database Objects - SQL Server
Build database objects using the SQL Server integration with the .NET Framework common language runtime (CLR).
-
Get Started With CLR Integration - SQL Server
This article describes the namespaces and libraries required to compile database objects using the Microsoft SQL Server integration with the .NET Framework CLR.
-
Data Access From CLR Database Objects - SQL Server
CLR routines can access data from within a CLR database object by using the .NET Framework Data Provider for SQL Server, also referred to as SqlClient.