Posts
Sort by recent activity
Expand * doesn't pickup all the columns from a Temp Table
If you have something like this:SELECT [a].Field1, [a].Field2, [b].AnotherField1, [b].AnotherField2INTO #TempTableFROM TableA LEFT OUT...
SQL Prompt is not formatting IF statement correctly
The following SQL is not formatted correct.IF @CalculateHeld = 'Yes' BEGINSELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0DROP TABLE [#HeldFunds]END ELSE BEGINSELECT * FROM [#HeldFunds2] WHERE [...
Swap Sides doesn't swap the server names
When filling out the Connection information and you want to swap the connections it swaps everything except for the server names.
Rule BP011 (A comparison or expression is using NULL without explicit provision for a NULL value.)
This rule is not appropriate for a CASE statement.
CASE [s2].[SchoolID]
WHEN NULL THEN .[SchoolNumber]
ELSE [s2].[SchoolNumber]
END AS [SchoolNumber]
Unless what you're saying is that .SchoolNumber...
Multiple Issues on the same line are hidden
If your SQL has multiple rule violations, it only shows one of the rules. It should show ALL the rule violations.
PE006 (TABLE HINT is used)
Would like this to be more granular.
When doing reporting I use the WITH (NOLOCK) to avoid locks on tables.
I would like to be able to disable specific warnings about specific hints.
Rule BP011 (A comparison or expression is using NULL without explicit provision for a NULL value.)
This rule is not appropriate for a CASE statement.
CASE [s2].[SchoolID]
WHEN NULL THEN .[SchoolNumber]
ELSE [s2].[SchoolNumber]
END AS [SchoolNumber]
Unless what you're saying is that .SchoolNumber...
PE006 (TABLE HINT is used)
Would like this to be more granular.
When doing reporting I use the WITH (NOLOCK) to avoid locks on tables.
I would like to be able to disable specific warnings about specific hints.
Multiple Issues on the same line are hidden
If your SQL has multiple rule violations, it only shows one of the rules. It should show ALL the rule violations.
Bug: When databases are identical....
When databases are identical it allows you to click the "Deploy" button, which then comes up and tells you that you didn't select anything to deploy....well, there is nothing to deploy.
In V11, the...