Posts
Sort by recent activity
Limit On SQL Statement Length?
I have found that I have problems suggestions not working reliably on long statements, and it doesn't appear to be a specific number of lines, but more a number of characters.
In the sample below, ...
Format SQL and Spaces vs. Tabs
Given the way things work I would like to see an option in the Format SQL options to use tabs instead of spaces for indenting. The reason is if you have formatted your code with SQL Prompt and then...
Formatting and "First column" option
When formatting my SQL code I prefer the first column in the SELECT clause to start on a new line, but I don't want the first table name to start on a new line in the INTO or FROM clause.
i.e. I wa...
Formatting and ;
When I format my SQL code SQL Prompt is putting a space before the end of command terminator (;).
Given:
SELECT
1 AS Field1,
2 AS Field2,
3 AS Field3
INTO
#Test;
If you format it it ends ...
Indent problem with new release and * expand
Given this code:SELECT
1 AS Field1,
2 AS Field2,
3 AS Field3
INTO #Test;
SELECT
*<cursor>
FROM #Test;
If you hit TAB you end up with:SELECT
Field1,
Field2,
Field3
FROM ...
Temp table doesn't trigger suggestion
Given this code:
SELECT 1 AS field
INTO #Temp
SELECT
*
FROM <cursor>
If you type a # nothing is suggested, even as you continue with type Temp nothing is suggested. If you hit ctrl-space suggestion...
Case not updated after Enter
If I hit enter directly after a keyword SQL Prompt doesn't convert it to upper case.
i.e.
Select<enter>
I have turned enter off as a insertion key, but that shouldn't cause a problem, as the case i...
No Snippets
I just upgraded to SQL Prompt 4 and I now have no snippets, not even any standard/default ones.
I tried the snippet importer and it does nothing and just returns this:
SQL Prompt 4 Snippets Importe...
Qualified fields not included in suggestions for temp tables
I reported this before in another thread, but it appears to have gotten ignored since the thread was started for a different issue:http://www.red-gate.com/messageboard/vi ... 0505#20505
Given this ...
3.8 not identifying temp table
Given this code:
SELECT DISTINCT
*
INTO #Test
FROM MASTER.dbo.spt_values
SELECT *
FROM #<cursor>
SQL Prompt 3.8.0.244 will not have #Test as a suggestion. If you remove DISTINCT it will. Then once ...