To create a SQL CLR stored procedure query
- 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.
- Click
OK.
- Continue to build your query.