From the Visual Studio IDE, set the
Type Stored Procedure option in your OpenESQL Assistant options to
SQLCLR.
Create a new SQL CLR Database Project or
SQL Server Database Project.
Start the OpenESQL Assistant.
Connect to a Microsoft SQL Server data source.
Check the box next to a table name.
Click a query type from the list.
Check
Generate Query as a SQLCLR Stored Procedure.
In the
SP name field, type a name for the stored procedure. Alternatively, accept the default value. The generated program name is the same
as the stored procedure name.