Activity overview
Latest activity by Alza
ST003 - Entire procedure body not enclosed within BEGIN...END rule is stupid
Consider this temporary stored procedure code:CREATE OR ALTER PROCEDURE #ST003_EXAMPLE AS
BEGIN
PRINT 'Great';
END;
-- some debug after END...
THROW 50000, 'Really!', 1;
GO -- Separated stateme...
Duplicate https://forum.red-gate.com/discussion/86193/sql-prompt-10-unable-to-check-for-updates / comments
Duplicate https://forum.red-gate.com/discussion/86193/sql-prompt-10-unable-to-check-for-updates
Both sides of comparison are same
During major rewriting of legacy code we made quite simple mistake:
Rewrite JOIN ON/WHERE condition to state when both sides were same. Usually because left/right sides were swapped in source and c...