3 ms·
The humorous thing is Microsoft doesn't think debugging should be allowed in their latest SQL Server Management Studio release. Imagine trying to debug SQL stor
by jshowa3 7y ago
The humorous thing is Microsoft doesn't think debugging should be allowed in their latest SQL Server Management Studio release. Imagine trying to debug SQL stored procedures without it.
While I agree SQL stored procedures should be slim, I've had situations where I had to write very complex ones even though I argued against it.
- SahAssar 7y agoIs there any SQL engine that does debugging of functions/stored-procedures well? If there is a way to do it well in postgres I'd love to know about it!
- jshowa3 7y agoI just got started with postgres and have hated the procedure syntax so much that I've begged my manager to go to MSSQL or upgrade to the latest database version (I'm currently on 9.3). And fortunately, the database is small enough where this really isn't a big deal. But my guess would be to search on the web for one and try them out. Apparently, pgAdmin 4 has this capability. But I've never used it. They're usually disabled on default install and have to be enabled at the server. pgAdmin calls it the pldbgapi extension.