Once you have built the SQL CLR stored procedure query, you can test it in the same manner as you test other SQL queries with in OpenESQL Assistant.
Microsoft also provides tools via Server Explorer or SQL Server Management Studio to test a SQL CLR stored procedure once it has been deployed.
