Comments
Sort by recent activity
I haven't seen anything about alias=expression being deprecated. Just 'alias=deprecated.
I wouldn't count it as a code smell. It's not ANSI, but the expression as alias isn't remotely readable in complex code. Once you have expressions that grow and don't format well in the horizontal space, finding the alias can be cumbersome. / comments
I haven't seen anything about alias=expression being deprecated. Just 'alias=deprecated.
I wouldn't count it as a code smell. It's not ANSI, but the expression as alias isn't remotely readable in c...
Sent a note to the team. / comments
Sent a note to the team.
What do you mean? You can use the equal alias. Do you mean somehow Prompt puts a value there? Can you provide an example of pre and post formatting? / comments
What do you mean? You can use the equal alias. Do you mean somehow Prompt puts a value there? Can you provide an example of pre and post formatting?
Very true, I'll pass along. / comments
Very true, I'll pass along.
Reproduced in 8.8.8.2657 as well. I'll report this. / comments
Reproduced in 8.8.8.2657 as well. I'll report this.
I get that the alias isn't appearing first, which seems like a problem. however, the columns with the alias appears just below the item you've boxed in. If you arrow down3 times, you'll have t1.col1. I think this is a sorting issue with the product. I'll report this. / comments
I get that the alias isn't appearing first, which seems like a problem. however, the columns with the alias appears just below the item you've boxed in. If you arrow down3 times, you'll have t1.col...
Which version of SQL Source Control and Git? I haven't seen this. Is this an empty repo or one that you've pulled down source from a remote that is in SQL Source Control format? / comments
Which version of SQL Source Control and Git? I haven't seen this. Is this an empty repo or one that you've pulled down source from a remote that is in SQL Source Control format?
You are welcome. Glad to help. / comments
You are welcome. Glad to help.
First, which version are you using. Prompt revs so often that "latest" is hard to know.
I don't know we can do this exactly. If you edit formatting styles, there is an INSERT item on the left. [image]
Under here, I think the last item in the first row matches closely to what you want with the always option selected. We don't have a good option to only put the first item on the end of the line. That seems like an option that inconsistently lists items to me, but that may be what you want. I'd suggest you add this to Uservoice if it's important to you. [image]
Below that, the VALUES item list, second item in second row, might be what helps you with the Values clause. [image] / comments
First, which version are you using. Prompt revs so often that "latest" is hard to know.
I don't know we can do this exactly. If you edit formatting styles, there is an INSERT item on the left.
Unde...
It's not possible to customize the tree right now. We put all the objects in the folder as a flat format, which is the same format used by Compare, DLM, etc. I'm not sure this is something we'd want to support as how would you designate the procedures in SSMS as being in a folder? We link from SSMS to a similar structure in the VCS. / comments
It's not possible to customize the tree right now. We put all the objects in the folder as a flat format, which is the same format used by Compare, DLM, etc. I'm not sure this is something we'd wan...