Posts
Sort by recent activity
BUG: incorrect alias attempt
IF EXISTS ( SELECT c.name as column_name
FROM sys.schemas s
JOIN sys.tables t ON s.schema_id = t.schema_id
JOIN sys.columns c ON...
Error formatting MERGE statement in WHEN NOT MATCHED BY
WHEN NOT MATCHED BY SOURCE AND SomeID = @SomeID THEN DELETE
The above code inside a MERGE statement is giving SQL Prompt problems causing it to show a Syntax error underlining column SomeID.
Error when formatting otherwise valid SQL with subqueries
Repro:USE tempdb;
CREATE TABLE #tmp (id INT, name VARCHAR(100))
CREATE TABLE #tmp2 (id INT, name VARCHAR(100))
DELETE FROM #tmp
WHERE id = (
SELECT id
FROM ...
Manage multiple Extended Properties, not just MS_Description
I am evaluating SQL Doc and am curious if there is a way to have the tool allow us to edit Extended Properties besides only the one named MS_Description. At present it is displaying other named pro...
"Find Unused Variables and Parameters" at command line
I am a big fan of SQL Prompt! The "Find Unused Variables and Parameters" feature is very useful and has allowed us to clean up many wasteful declarations as we work on existing objects. All of our ...