Hi there, I need to debug this query which is causing us problems and it's been awhile since I've written any SQL. I'll continue to hammer away at this but I'm missing some fundamental concept ...

Product Reviews Debugging SQL DevPartner DB might soon become your SQL toolbox fave. By Mike Gunderloy 12/18/2002 DevPartner DB provides a standalone environment for testing SQL Server 7.0 and 2000 ...

I write my SQL in Visual Studio, which has not merely syntax highlighting but Intellisense and type checking. Because I'm generally writing LINQ. You can use LINQPad to write ad-hoc queries and ...