Some of us would like the option for formatting of table declarations to not only align [tabify] column names (indented one tab), but also columnize/tabify the data types and nullability so that table definitions are grid-like. Constraints per column are are far more variable and therefore require more of a free format or sometimes pushing them to subsequent lines, but at minimum, the ColumnName, DataType and Nullability should be optioned to columnize by default.

When there are hundreds or thousands of tables in a db schema, I'm used to scanning table definitions, and having them organized grid-like saves my eyeballs time and frustration. I realize not everyone organizes table schema in this way, but I manually format every table definition this way where I am allowed.

Hello,

So I love the suggestion feature where I'm able to type in an object and the code appears to copy. Home run with this feature I can't thank you enough for it.

I was wondering if it would be possible to expand on it though.

Here is a sample. I'm looking to alter an object, let's say a stored proc...
I usually begin by typing EXEC <name> to trigger the suggestion for stored procs to give me the object.

Once the suggestion finds the object, the script contents appears in a side window.

Using the COPY button in the right corner, I copy the next and paste to my current session window (overriding the previous EXEC <name> statement)
However I still need to change the CREATE statement to an ALTER statement.

Then I remember that I can use F12 to Script Object as ALTER. That's great, however it opens the object in a new window.

Have you ever been buried with so many tabs opened that are either pinned/not pinned during business hours? It sometimes becomes a (slight) problem when you see numerous SQLQueryXX.sql tabs listed and you have to remember to go back and close the previous one that you used to trigger the suggestion.

So my question - would it be possible to have an ability to have something like a COPY AS ALTER button, similar to the COPY button in the screenshot?

The functionality is already there, you'd just be adding a nice convenient button that would really be appreciated!

Thank you for your consideration.

One of the most tedious elements of writing T-SQL is handling of proper comparisons in the WHEN MATCHED AND ... THEN UPDATE clause of a MERGE statement.
For example, to compare a single nullable target and destination column you should compare:

SRC.column <> TGT.column
OR (SRC.column IS NULL AND TGT.column IS NOT NULL)
OR (SRC.column IS NOT NULL AND TGT.column IS NULL)

I'm not sure on exactly how would be best to handle this but it would be great if SQL Prompt could somehow auto-populate these clauses. Or even better would be some way to generate an entire merge statement for two similar tables. When merging tables with many columns, this would be a huge time-saver. Additionally, these comparisons are highly susceptible to user-error do to the repetitive nature of the task.

At the moment a warning is given "Non-scalar subquery in place of a scalar" when trying to assign a variable to the result of a query filtered by the primary key column. In this case only one result can be returned so the warning appears inaccurate and wrapping the result in a TOP 1 { } ORDER BY statement seems an overkill just to remove the warning. This is kind of a special case however where the subquery contains only one table filtered with "=" on the primary key column, but it is a very common one.

Example:
DECLARE @X = (SELECT ColumnX FROM dbo.Table WHERE PrimaryKeyColumn = @Y).

I want to be able to quickly switch between active styles.
I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.

I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the styles submenu, so that I can get to them quickly with the keyboard.

Hope that's clear enough. Cheers.

I realize my title is very vague.

Basically, I would like more control options over how styles are applied. Maybe I'm just really weird in how I format my SQL, but it seems like no matter how hard I try, I can never get the styles the way I want them.

I realize that it's impossible to make it perfect. But the basic idea is to get the formatter to do what you would normally do the majority of the time.

For example....the majority of the time, I prefer the following...

For JOIN clauses, all join criteria is in the same line:

JOIN dbo.Table t ON t.Foo = x.Foo AND t.Bar = x.Bar

But for WHERE clauses, I prefer them to be on separate lines:

WHERE x.Foo = 1

    AND x.Bar = 2

    AND y.Baz = 123

Unfortunately, the formatter only allows one or the other.

Another example, is with lists:
For GROUP BY, I like them all on the same line

GROUP BY x.Foo, y.Bar, z.Baz

But for SELECT, I like the columns on separate lines (unless it's a short list, then put them all on the same line.)

Unfortunately, the formatter also does not allow this. So now all of my group by's look like this:

GROUP BY x.Foo

    , y.Bar

    , z.Baz

I have a few more examples, but they're more oddball things that I like to do that are probably not as common.