Posts
Sort by recent activity
SQL Prompt - strange behavior with ROLLBACK TRANSACTION
Hello,in my stored procedures I often use the patternIF @somecindition = TRUE
BEGIN
COMMIT TRANSACTION;
END;
ELSE BEGIN
ROLLBACK TRANSACTION;
END;</code>IF @somecondition = TRUE
BEGIN
COMMIT TR...
SQL Prompt - strange behavior when formatting 'CROSS APPLY'
When using SQL Prompt to format my code, it seems to mess up the indentation each time I use 'CROSS APPLY' or 'OUTER APPLY', as you can see in this example:SELECT *
FROM
sys.[objects]
CROSS APP...
SQL Prompt - strange formatting behavior with "TOP x"
Why does SQL Prompt format SQL statements differently when using "TOP x"?Take these two statements as an example. I would have expexted the exact formatting except for the additional two words "TOP...
Handling two interconnected databases with SQL Source Control
I have an ETL process completely coded in SQL (no change of techology wanted) that uses a StagingDB where the incoming data is stored in the source format and a QueryDB where data is stored in nati...