Share via


CLR Stored Procedures (ADO.NET)

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 Books Online for the version of SQL Server you are using.

SQL Server 2005

SQL Server 2008

CLR Stored Procedures

CLR Stored Procedures

See Also

Other Resources

Creating SQL Server 2005 Objects in Managed Code

ADO.NET Managed Providers and DataSet Developer Center