Comments
Sort by recent activity
I would say:
Install SQL Prompt 3
Set the "Cache Folder", "Options Folder", and "Snippets Folder" values in the registry under "HKCU\Software\Red Gate\SQL Prompt 3" to another directory.
Move your configuration files to the new location
Upgrade to SQL Prompt 4
Notice that you have no Snippets, not even default ones
I have found that if I remove the "Snippets Folder" registry entry that SQL Prompt 4 creates the default snippets and I was then able to move them to a safe location and change the registry value back. / comments
I would say:
Install SQL Prompt 3
Set the "Cache Folder", "Options Folder", and "Snippets Folder" values in the registry under "HKCU\Software\Red Gate\SQL Prompt 3" to another directory.
Move your...
I ended up going into the standard SSMS Tools, Option, Text Editor, All Languages, Tabs and setting the Indenting option to Block so that it kept the indent level at the same level as the previous line.
At least that helps until you can get the next release out. / comments
I ended up going into the standard SSMS Tools, Option, Text Editor, All Languages, Tabs and setting the Indenting option to Block so that it kept the indent level at the same level as the previous ...
ATurner said:
Hi All This behavior has been changed in todays release.
The important release note reads: Altered Export to Excel to treat numeric values as numbers in Excel. Does this release also fix the horrible lag in typing in a script that existed in 10.12.5? (10.12.3 claimed to fix it for large snippets, but in 10.12.5 I had the lag even with small snippets. Another reason I rolled back to 10.12.1.) / comments
ATurner said:
Hi AllThis behavior has been changed in todays release.
The important release note reads: Altered Export to Excel to treat numeric values as numbers in Excel.Does this release...
They may call this a feature, but it absolutely is a BUG! Saying you can just convert the text to numbers in Excel is insane. Not only do you have to pick out just the correct columns/cells, then when you do it it takes Excel a long time. (It takes longer to fix all of text than it does to export.) In one example I gave up after Excel was converting cells for more than an hour. I ended up downgrading SQL Prompt and re-exporting before Excel finished "fixing" the bad file. If this isn't fixed our company won't be renewing our support contract. (Why would we pay for upgrades when we can't install them because critical functionality is broken in the new versions.) / comments
They may call this a feature, but it absolutely is a BUG!Saying you can just convert the text to numbers in Excel is insane. Not only do you have to pick out just the correct columns/cells, then wh...
alphonseg said:
@ATurner, I'd really like to know how many users requested this change. Or was it just that someone at Redgate got a 'bright' idea?
Exactly. I just looked in UserVoice and I don't see that anyone requested or voted for this change. So now we have to request and vote to revert this change/"feature", or at least make it optional. Why? / comments
alphonseg said:
@ATurner, I'd really like to know how many users requested this change. Or was it just that someone at Redgate got a 'bright' idea?
Exactly. I just looked in UserVoice and I...
Jon_Kirkwood said:
Unfortunately I have to report that our development team have re-reviewed the decimal data type output to Excel concern and, with their current workload and available resources, have made the decision that this is not an item they are able to provide a fix for at this time.
As mentioned by @alphonseg there are workarounds within Excel are to use the Data > Text to Columns ribbon-menu option or right-click > Format Cells... context-menu options to change the formatting on these cells.
Apologies for any inconvenience this may cause with exporting to Excel; and whilst we cannot commit to a fix at this time it is possible that changes may occur in future releases.
@Jon_Kirkwood Really? They don't have time to pull the Excel export code out of the 10.12.1/2 version of the source code and replace the crap code that is in the current version? Don't make it look like what SSMS displays, that isn't why we want the data exported to Excel. The scientific notation display in Excel isn't/wasn't a bug. (If you insist on having the capability to export numbers as text make it an option that people can select.) That isn't a viable work-around... I can uninstall SQL Prompt, Install the old version, start SSMS, run the query, and export it again before Excel would get done converting the text to numbers. / comments
Jon_Kirkwood said:
Unfortunately I have to report that our development team have re-reviewed the decimal data type output to Excel concern and, with their current workload and available reso...
Or could SQL Prompt look to see if the IDENTITY INSERT option is turned on for that table, and if so include the IDENTITY column.
Michael / comments
Or could SQL Prompt look to see if the IDENTITY INSERT option is turned on for that table, and if so include the IDENTITY column.
Michael
Do I really have to delete everything in there, my settings and all, or just the cache files. (I deleted just the cache files and tried again.)
Try this version:
SELECT
S.status,
S.[high],
S2.LOW,
S.NAME,
S.number,
s2.[type]
INTO #Reason1
FROM MASTER.dbo.spt_values S,
MASTER.dbo.spt_values S2
SELECT *
FROM #Reason1 R
WHERE R.<cursor>
At <cursor> I only get high, number, status, and type as suggestions. (Name and Low aren't suggested.) / comments
Do I really have to delete everything in there, my settings and all, or just the cache files. (I deleted just the cache files and tried again.)
Try this version:
SELECT
S.status,
S.[high],
S2.LOW,
...
I don't want SQL Prompt to generate an alias for tables itself, I supply them myself.
Did you bother to try the code I supplied? Alias selection does normally work, but in the case I supplied it doesn't, at least not for me. The problem is specifically with temp tables that have qualified fields in the creation of the temp table. (Your example doesn't include temp tables, so I would expect it to work.) / comments
I don't want SQL Prompt to generate an alias for tables itself, I supply them myself.
Did you bother to try the code I supplied? Alias selection does normally work, but in the case I supplied it d...
Yes, I used the 'refresh all' button. I suppose that setting it to refresh the cache when opening a new window might resolve the problem, but I don't think it should be necessary. (The cache for the DB was refreshed the instant before the window was opened.) / comments
Yes, I used the 'refresh all' button. I suppose that setting it to refresh the cache when opening a new window might resolve the problem, but I don't think it should be necessary. (The cache for th...