Posts
Sort by recent activity
SQL Prompt does not recognize IS_ROLEMEMBER function during format (9.5.16.11294)
SQL Prompt formats thisSELECT IS_ROLEMEMBER('db_owner') ;
to
SELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalidBelow is some of the other function from https://docs.microsoft.com/en-us/sql/t...
SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
SQL Prompt formats SELECT IS_ROLEMEMBER('db_owner') ;toSELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalid.Some other functions from sitehttps://docs.microsoft.com/en-us/sql/t-sql/functions/f...
SQL Prompt misformats IS_ROLEMEMBER function (version 9.5.16.11294)
SQL Prompt formats SELECT IS_ROLEMEMBER('db_owner') ;toSELECT [IS_ROLEMEMBER]('db_owner') ;Which becomes invalid.Some other functions from sitehttps://docs.microsoft.com/en-us/sql/t-sql/functions/f...
SQLPrompt 9.5.18.11513 still misformats IS_ROLEMEMBER and makes the sql statement invalid
SQLPrompt 9.5.18.11513 formatsSELECT IS_ROLEMEMBER('db_owner')toSELECT [IS_ROLEMEMBER]('db_owner') and the sql becomes invalidThe list of sql server functions can be found athttps://docs.microsoft....
SQL Prompt 9.5.8.10521 Timeout notification windows
These windows just started popping up, they are modal windows and seems like when some timeout happens in sqlprompt they pop up, unless you close the window you can't do anything with SSMS. They ar...
SQL Prompt V 9.3.0.6627 is removing aliases from columns during format
SQL Prompt is removing already assigned aliases if the column is used in an inline table valued function and the column exists in multiple tables used in the query. The result is query is failing s...
SQLPrompt fails to format a valid SQL (version 8.0.2.1508)
Trying to format this code I get "Error applying column alias style", I do not see anything highlighted as error.
SQL Prompt version 8.0.0.1241 is moving comments between commas
When I format this statement with sql prompt
SELECT * FROM sys.objects WHERE OBJECT_ID IN (/*1=*/ 0, /*2=*/ 0, /*3=*/ 0, /*4=*/ 0, /*5=*/ 0, /*6=*/ 0)
it formats to below, it moves comments aroun...