Comments
Sort by recent activity
I have found that SQL Prompt will work sometimes from within single quotes, but it is not always as reliable.
I do a lot of work with OPENQUERY and what is in the quotes is an sql statement.
To get it to prompt, I have to manually activate with Ctrl+Space.
The problem I have is the snippets do not show. I have to click on the snippet icon to see them (not that big a deal).
I would like to see an option to control when to ignore single quotes. That way, those that want the prompting can use it.
Thanks
Bill / comments
I have found that SQL Prompt will work sometimes from within single quotes, but it is not always as reliable.
I do a lot of work with OPENQUERY and what is in the quotes is an sql statement.
To get...
I am on version 3.6. I can set the prompting to manual and when I type the snippet I can press TAB and it will insert it. / comments
I am on version 3.6. I can set the prompting to manual and when I type the snippet I can press TAB and it will insert it.
David,
Thanks for the suggestion. Editing the file worked great.
I was able to do a find and replace.
When I restarted SSMS, the links were correct.
Suggestion for a future release.
Next to the "Unlink database..." add an Edit Link. / comments
David,
Thanks for the suggestion. Editing the file worked great.
I was able to do a find and replace.
When I restarted SSMS, the links were correct.
Suggestion for a future release.
Next to the "Un...
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 ...