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