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:

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

1. CLR Stored Procedures

See also

• Creating SQL Server 2005 Objects In Managed Code
• ADO.NET Overview