I'm picturing a Management Studio query window type of interface, but inside of Visual Studio. I'm pretty sure it doesn't exist, but want to ask to confirm before putting in a feature request. The reason it's needed is that when working with
triggers in SQL CLR, the Inserted and Deleted tables are essential to the functionality, but cannot be accessed from Management Studio. That makes debugging really tough when a query does not yield the expected results, because similar queries can't
be easily plugged in and executed.
Also (a related comment / question / request), is it contemplated to make the SQL CLR functionality more fault tolerant? Once ANY exception is thrown, NO further queries can be executed. That also makes it really difficult to debug when a query
isn't working right, as it requires countless re-executions of the code to diagnose the issue.
View Complete Post