Comments
Sort by recent activity
If I do not have the WITH statement, the format works properly.
I will check the values when I get back into the office and let you know for sure. / comments
If I do not have the WITH statement, the format works properly.
I will check the values when I get back into the office and let you know for sure.
Chrisk5,
Here are the values I have set for the New lines options:
First Column = True
Each subsequent column = True
Contents of parentheses = True
Closing parenthesis = True
Join condition = True
Indent subclasses = False
Align join condition with JOIN = False
If I set the Align join... to True here is what the statement will look like:
FROM
BillingProcess.dbo.Billing AS b WITH (NOLOCK)
JOIN BillingProcess.dbo.v_Terms AS vt WITH (NOLOCK)
ON b.YRTR = vt.Term
JOIN BillingProcess.dbo.BillingType AS bt WITH (NOLOCK)
ON b.BillingTypeId = bt.BillingTypeId
If I set it to False and remove the WITH clauses this is what I want it to look like:
FROM
BillingProcess.dbo.Billing AS b
JOIN BillingProcess.dbo.v_Terms AS vt
ON b.YRTR = vt.Term
JOIN BillingProcess.dbo.BillingType AS bt
ON b.BillingTypeId = bt.BillingTypeId
I am expecting the same behavior as the second example above when the WITH clause is present. I want the ON clause to be indented. It makes for easier readability. / comments
Chrisk5,
Here are the values I have set for the New lines options:
First Column = True
Each subsequent column = True
Contents of parentheses = True
Closing parenthesis = True
Join condition = True
...
David,
I too would like to see support for SSDT. I would like to have all features available that are offered in SSMS and VS 2010 with pre-SSDT database projects. / comments
David,
I too would like to see support for SSDT. I would like to have all features available that are offered in SSMS and VS 2010 with pre-SSDT database projects.
What is the status of SP-3928? / comments
What is the status of SP-3928?
David,
Thanks for the reply.
The format of entering the url to the TFS server looked similar to VS2008 and it does not work with TFS 2010.
I found that when I enter the full url (server:port/collection) I can connect to TFS 2010. / comments
David,
Thanks for the reply.
The format of entering the url to the TFS server looked similar to VS2008 and it does not work with TFS 2010.
I found that when I enter the full url (server:port/collec...
David,
I would like to have the following feature in VS. When a file is created/opened, connect to the server and database specified in the project properties. If the "Target Connection" has not been set, then prompt for the connection information.
This would allow SQL Prompt to function more closely like it does in SSMS. / comments
David,
I would like to have the following feature in VS. When a file is created/opened, connect to the server and database specified in the project properties. If the "Target Connection" has not be...
I apoligize for the delay.
The error does NOT happen when I bring up the candidate list.
The candidate list comes up like it is supposed to.
The error occurs when I select (TAB or double click) an item on the candidate list.
This only happens in visual studio.
If I double click on an item in the list visual studio crashes.
If I use tab to select the item I get the exception error message.
I can clear the cache an I still get the error. / comments
I apoligize for the delay.
The error does NOT happen when I bring up the candidate list.
The candidate list comes up like it is supposed to.
The error occurs when I select (TAB or double click) an ...