Comments
Sort by recent activity
Just uninsteall/reinstall? Or should I do some manual cleanup before reinstalling? / comments
Just uninsteall/reinstall? Or should I do some manual cleanup before reinstalling?
I hit the TAB key.
So I type...
SELECT<TAB><TAB>*<ENTER>
FROM<TAB><TAB>dbo.MyTable<ENTER>
where<TAB><TAB>1 = 1;
My insertion keys for SQL Prompt at ENTER and TAB. Everything else is unchecked. / comments
I hit the TAB key.
So I type...
SELECT<TAB><TAB>*<ENTER>
FROM<TAB><TAB>dbo.MyTable<ENTER>
where<TAB><TAB>1 = 1;
My insertion keys for SQL Prompt at ENTER and TAB. Everything else is unchecked.
I wanted to chime in with my $0.02.
I also find the capitalization annoying at times, but I would like the ability to set the capitalization for reserved words on an individual basis.
For example, I use smallint rather than SMALLINT, but I use Scope_Identity() rather than SCOPE_IDENTITY(). I prefer to use sentence style casing for reserved words.
Since we all seem to have our own personal preference it would be nice to have a way to set the capitalization for each word. This would give the greatest flexibility. I could make tinyint be TiNyInT if I wanted to. / comments
I wanted to chime in with my $0.02.
I also find the capitalization annoying at times, but I would like the ability to set the capitalization for reserved words on an individual basis.
For example, ...
Awesome! Thanks! / comments
Awesome! Thanks!
I second those suggestions / comments
I second those suggestions
Sql Prompt works for me with VS SP1 installed. For some reason the menu was disabled in SSMS, but the autocomplete still worked. I uninstalled Sql Prompt and reinstalled it and all is good again. / comments
Sql Prompt works for me with VS SP1 installed. For some reason the menu was disabled in SSMS, but the autocomplete still worked. I uninstalled Sql Prompt and reinstalled it and all is good again.
I figured it out. You have to put the <DATABASE> tag on the folder and not the file. / comments
I figured it out. You have to put the <DATABASE> tag on the folder and not the file.
petey wrote:
Does the SQL Backup Agent service startup account have rights to that network share?
Yes...everyone has access to that share. / comments
petey wrote:
Does the SQL Backup Agent service startup account have rights to that network share?
Yes...everyone has access to that share.
Yes, my styles are set to UPPERCASE for all 3 options (keywords, functions, and types). This works fine in SSMS but not in VS.
I do not have those style options because I am using Standard Edition. / comments
Yes, my styles are set to UPPERCASE for all 3 options (keywords, functions, and types). This works fine in SSMS but not in VS.
I do not have those style options because I am using Standard Edition.
I tried what you suggested and whenever I had very simple scripts the capitalization worked fine, but I know I have scripts where "go" doesn't capitalize. I will respond with more information when I encounter the behavior again. / comments
I tried what you suggested and whenever I had very simple scripts the capitalization worked fine, but I know I have scripts where "go" doesn't capitalize. I will respond with more information when...