To create a SQL CLR stored procedure query

  1. From the Visual Studio IDE, set the Type Stored Procedure option in your OpenESQL Assistant options to SQLCLR.
  2. Create a new SQL CLR Database Project or SQL Server Database Project.
  3. Start the OpenESQL Assistant.
  4. Connect to a Microsoft SQL Server data source.
  5. Check the box next to a table name.
  6. Click a query type from the list.
  7. Check Generate Query as a SQLCLR Stored Procedure.
  8. 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.
  9. Click OK.
  10. Continue to build your query.