Activity overview
Latest activity by intGod
Feature request: extra format option for join tables
Currently, I can get SQL Prompt to format my SQL like this.SELECT
tbl.name AS TableName,
col.name AS ColumnName
FROM
sys.tables AS tbl
INNER JOIN
sys.columns AS col
ON
...
Why does the formatting not update the casing of the fields?
Hi,See enclosed image. The columns are all defined in the table as UPPERCASE. For some reason, when formatting the document, it recognizes the FIDPERS in the second half of the union, but it doesn'...
.NET Error when trying to run SQL Prompt Command Line
When running the SQL Prompt command line, I get this error.Unhandled Exception: System.IO.FileLoadException: Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, Public...
Wow Dan, that is really great. Thank you! / comments
Wow Dan, that is really great. Thank you!
Thanks for getting back to me, Dan! That is unfortunate behaviour and feels like "kidnapping". Unfortunately that means I will have to uninstall the software and my client won't go ahead with ordering the 10 licenses I asked for because they are unsure what else will be broken with SQL Prompt if they decide to not renew the license after a year [image] Is there no option to check if there is a valid license and only kidnap the 'auto list members' if there is a valid license available? Maybe the situation where only a certain members of people using the same install of SSMS has a valid key is unique but I doubt it .. But thank you for getting back to me even if the news is not what I hoped for. / comments
Thanks for getting back to me, Dan!That is unfortunate behaviour and feels like "kidnapping". Unfortunately that means I will have to uninstall the software and my client won't go ahead with orderi...
Best practice to only use a TABLE ALIAS in the UPDATE statement so you will always have to have it explicitly in the FROM statement / comments
Best practice to only use a TABLE ALIAS in the UPDATE statement so you will always have to have it explicitly in the FROM statement
SQL Prompt disables "auto list members" in Transact-SQL Editor when a license is not active
We are working on a shared DEV environment. I installed SQL Prompt and slapped my personal license on it. Unfortunately, my colleagues who do not have a license now have their autocomplete disabled...