Comments
Sort by recent activity
I found a case where SQL Prompt Format SQL attempts to qualify a table name when it shouldn't.
Here is the SQL script to create objects required: CREATE SCHEMA aa;
GO
CREATE SCHEMA bb;
GO
CREATE TABLE aa.Apples (Species VARCHAR(20) NOT NULL);
CREATE TABLE bb.ap (apnme VARCHAR(20) NOT NULL);
DELETE ap
FROM aa.Apples ap
Now run Format SQL. I realize the DELETE statement is somewhat contrived. Assume there is a more complex JOIN required.
The last statement becomes this.
DELETE bb.ap
FROM aa.Apples ap;
/ comments
I found a case where SQL Prompt Format SQL attempts to qualify a table name when it shouldn't.
Here is the SQL script to create objects required:CREATE SCHEMA aa;
GO
CREATE SCHEMA bb;
GO
CREATE TAB...
Some feedback based on 1 day of use.
Tab coloring - I really like the extra stripe of color at the bottom of the screen. For some reason, this is more noticeable to me than the tab color at the top.
Having "insert semicolons" on by default was unexpected. I found the option easily enough to turn it off. Why is it on by default? / comments
Some feedback based on 1 day of use.
Tab coloring - I really like the extra stripe of color at the bottom of the screen. For some reason, this is more noticeable to me than the tab color at the top...
I'm having some trouble with SQL Format fixing the case of column names.
Our c# app uses DataSets which require data coming from SQL Server to match the DataSet column names case-sensitive.
I want to reformat but I want an option to not change column names to match the SQL column name. It appears there would be room on the Format -> Styles -> Case tab. / comments
I'm having some trouble with SQL Format fixing the case of column names.
Our c# app uses DataSets which require data coming from SQL Server to match the DataSet column names case-sensitive.
I want ...
Found a new problem although it may not be with SQL Prompt.
In Snippet Manager, edit a snippet. Then click "Find out more" at the bottom of the form. I get a new browser window with a 404 page. / comments
Found a new problem although it may not be with SQL Prompt.
In Snippet Manager, edit a snippet. Then click "Find out more" at the bottom of the form. I get a new browser window with a 404 page.
Confirmed that "Format SQL" doesn't move the cursor anymore except when in the middle of several lines of white space which is fine. Don't know why I didn't report this months ago! Thanks for fixing this!
Confirmed that Shift-F5 is fixed as well.
The options window closes fine now. It may have been related to several slow network drives that I use via a VPN. I've noticed file save/open dialogs responding slowly in other apps as well. A reboot fixed the problem. / comments
Confirmed that "Format SQL" doesn't move the cursor anymore except when in the middle of several lines of white space which is fine. Don't know why I didn't report this months ago! Thanks for fixin...
Very nice, Aaron. It works 99% perfectly. :-)
When the cursor is in the middle of a line or at the end, it works perfectly. However, when the cursor is at the beginning of a line, the window scrolls one line down and the cursor is moved up one line.
To reproduce:
1. Put cusor at beginning of a line.
2. Run "Format SQL".
3. Note display is scrolled up 1 line and cursor position is changed.
4. Run "Format SQL" again.
5. Note that nothings moves on the screen.
One more thing.....
Not new to this beta, but the Options window takes roughly 15 seconds to close now. The first 5-7 seconds are completely frozen without a wait mouse cursor. In prior major releases, this dialog closed quickly. / comments
Very nice, Aaron. It works 99% perfectly. :-)
When the cursor is in the middle of a line or at the end, it works perfectly. However, when the cursor is at the beginning of a line, the window scroll...
Also, "run current statement" (shift-F5) seems broken now.
With only a single statement in a file, it selected all but the last 2 characters. I can send a screenshot if needed. / comments
Also, "run current statement" (shift-F5) seems broken now.
With only a single statement in a file, it selected all but the last 2 characters. I can send a screenshot if needed.
Problem: "Format SQL" causes window contents to scroll sometimes to a position that is not useful.
After using, "Format SQL" the window is usually scrolled so the cursor is on the last visible row. Then I always need to scroll the window so I can continue working.
If "Format SQL" doesn't change anything, the window isn't scrolled at all.
Suggestion: maintain the current scroll position. If this isn't possible, scroll the window so the cursor is centered vertically.
(If this is the wrong place for this feedback, please instruct me how to provide this in a better forum.) / comments
Problem: "Format SQL" causes window contents to scroll sometimes to a position that is not useful.
After using, "Format SQL" the window is usually scrolled so the cursor is on the last visible row....
I'm fairly certain this issue is new. I love the new loading dialog and that it's placed at a consistent place on the screen.
The UI freeze is before the dialog is shown. As soon as the small window appears, the UI is responsive again.
I'm unable to reproduce locally even with a large number of objects. Typically, I work remotely, using db servers remotely via VPN connections. / comments
I'm fairly certain this issue is new. I love the new loading dialog and that it's placed at a consistent place on the screen.
The UI freeze is before the dialog is shown. As soon as the small windo...
I notice a lag of 2-3 seconds after using Ctrl-Shift-D to refresh suggestions.
I would like to enable auto-refresh of the suggestion but this lag makes it quite painful when the SSMS UI freezes for 2-3 seconds. This is a development db with several devs making changes.
Here are the counts of objects in the current database.
74 CHECK constraints
2405 Default or DEFAULT constraints
432 FOREIGN KEY constraints
3 Inlined table-functions
1925 PRIMARY KEY or UNIQUE constraints
69 Scalar functions
1399 Stored procedures
67 System tables
12 Table functions
17 Triggers
2124 User tables
305 Views / comments
I notice a lag of 2-3 seconds after using Ctrl-Shift-D to refresh suggestions.
I would like to enable auto-refresh of the suggestion but this lag makes it quite painful when the SSMS UI freezes for...