Search
-
Moved: Does anyone else's Community CLI not work?
-
Smart Rename not finding all instances of item to change
I have an Azure SQL Server DB, and am using SSMS 20.1 with SQL Prompt 10.14.12.7945. When I use SQL Search it correctly finds the 4 instances of a field I want to rename (2 tables, 1 sproc, 1 view). However when I use Smart Rename it only finds the single instance in the object selected and nothing else. Has anybody else… -
Does anyone else's Community CLI not work?
-
Re: SmartAssembly 8 - "System.IO.FileNotFoundException: Could not load file or assembly" error
-
formatting if else if statements
-
Re: Formatting requests - post them here
ELSE IF as one operator instead of:IF...ELSE IF ... ELSE IF ... ELSE IF statement should look likeIF...ELSE IF...ELSE IF...ELSE BOOLEAN OPERATOR indentation (EDIT: Option is in Expressions/Parentheses content) instead ofWHERE condition AND(condition OR condition) WHERE condition AND(condition OR condition) -
SQL Prompt - strange behavior with ROLLBACK TRANSACTION
Hello, in my stored procedures I often use the pattern IF @somecondition = TRUE BEGIN COMMIT TRANSACTION; END; ELSE BEGIN ROLLBACK TRANSACTION; END; When I use SQL Prompt to format this code, the COMMIT TRANSACTION statement is correctly indented (as being in a BEGIN END block), but the ROLLBACK TRANSACTION always ends up… -
Re: SSMS Analysis Services with SQL Search
-
String concatenation formatting
SSMS 18.1, SQL Prompt 9.5.10. When concatenating strings, it'd be nice to align the "+" signs on a new line. For example, using the attached format file, I get the following, and the indentation increases with each concatenation, reaching extremes: SELECT CASE WHEN Col = 1 THEN 'Col 1' ELSE '' END + CASE WHEN Col = 2 THEN… -
OUTER APPLY doesn't honor 'Parentheses style' settings
This is how SQL Prompt 8.2.3.2750 formats the code:SELECT emp.EmployeeId ,history.WorkType1 - (history.WorkType2 + history.WorkType3) FROM Emp.Employee emp OUTER APPLY ( SELECT SUM( CASE WHEN hst.WorkType = 1 THEN DATEDIFF( DAY, hst.StartDate, CASE WHEN hst.EndDate < @ActualDate THEN hst.EndDate ELSE @ActualDate END ) ELSE…
>2117 results