Comments
Sort by recent activity
I see what you think I meant, but all I wanted was to have the totally different items on different lines so I could choose to add the new index and not drop the existing index. When they are on the same line with an arrow between them, it looks like the tool thought they were the same.
Just like if you have two tables with different names, you don't match them up, I would prefer that the two indexes be clearly denoted as distinct, different things so I could choose to keep both indexes. / comments
I see what you think I meant, but all I wanted was to have the totally different items on different lines so I could choose to add the new index and not drop the existing index. When they are on t...
On further review, it seems to be a bug with the option:
General, Commas, Multiple Line Statements
The two "Space after comma" settings. When they are not checked, there will be no space between the As and the first value. For example: select 'hi' as fred,
'bye' as barney
from test
is layed out as: select 'hi' as fred
, 'bye'as barney
from test
Apparenly it is removing the space from the wrong location. So the workaround is to turn on the Space after comma. Not a big deal, but it looks funny : select 'hi' as fred
, 'bye' as barney
from test
/ comments
On further review, it seems to be a bug with the option:
General, Commas, Multiple Line Statements
The two "Space after comma" settings. When they are not checked, there will be no space between t...
Installed on one of my machines easily, but had a dog of a time on the other. I searched for refactor, and deleted all of the files it found and it finally installed.
A couple of suggestions I have would be to:
A. Label something on the install process to make it clear what you are downloading (version number, CTP, Private Beta, etc). I am guessing that the thing we download fetches the new download, but it saw mine in cache and just kept installing it.
B. Have the new version purge the old version (of course this is beta, so I understand this one.)
Thanks. Like the product, I must say [image] / comments
Installed on one of my machines easily, but had a dog of a time on the other. I searched for refactor, and deleted all of the files it found and it finally installed.
A couple of suggestions I hav...
From Redgate About (which it would be nice if you included some form of copy/paste [image] :
Add-In Version 1.0.0.603
Rewriter Version: 5.7.0.430
SQL Compare Engine version 5.7.0.430
Ast Parser version 5.7.0.430
From SSMS Help, About:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600 / comments
From Redgate About (which it would be nice if you included some form of copy/paste :
Add-In Version 1.0.0.603
Rewriter Version: 5.7.0.430
SQL Compare Engine version 5.7.0.430
Ast Parser version 5.7...
It just depends on how much of the functionality you might use. I for one will use the SQL formatting all of the time, but none of the pure refactoring much at all, so for $295 (I thought you all were in UK, which is confusing since the price is in dollars American [image] that might be a bit steep. I really like the code formatting aspect though [image] / comments
It just depends on how much of the functionality you might use. I for one will use the SQL formatting all of the time, but none of the pure refactoring much at all, so for $295 (I thought you all ...
I can understand that [image] One more thing I didn't notice. It left the menus for the tool in SSMS. Clicking on the menus returns:
Microsoft SQL Server Management Studio
The Add-in supporting this command could not be loaded. Do you wish to remove the command?
If you choose yes, you can re-create the command by reinstalling the Add-in.
Yes No
Doing this removed the menu items, but the SQL Prompt menu item remains, disabled... / comments
I can understand that One more thing I didn't notice. It left the menus for the tool in SSMS. Clicking on the menus returns:
Microsoft SQL Server Management Studio
The Add-in supporting this c...
It is making me shut down Media Player 11 and remote desktop [image] / comments
It is making me shut down Media Player 11 and remote desktop
I totally agree about the usefulness. Web code, coworkers code that is rarely indented (I like private forums), etc. My favorite use so far has been to take some dynamic sql I had embedded in my code and straighten it out using refactor.
I like adding AS for sure, and certainly OUTER (I wouldn't quibble with INNER, mind you). Same pass I would like to apply dbo. to the table names (or whatever their actual schema is) and change the aliases to be the full name of the table (without dbo.))
I know it is personal preference, but the main reason for posting here tonight is to say: Great Job, I will probably use the refactor thing more than any of the other gadgets I am beta testing with you right now. It is super handy. / comments
I totally agree about the usefulness. Web code, coworkers code that is rarely indented (I like private forums), etc. My favorite use so far has been to take some dynamic sql I had embedded in my ...
That is cool. My reply might have sounded curt, but I was just interested in why you wouldn't consider it. ("Not consider" was strongish language, so I was interested if it was a dumb idea [image] )
I like the refactorings (word?) you have now (it is probably going to be one of the best addins to any product I have ever used, personally), but the main thing I would use would be the code reformatting. It is one of those features that I will use daily, and would be totally worth the price. / comments
That is cool. My reply might have sounded curt, but I was just interested in why you wouldn't consider it. ("Not consider" was strongish language, so I was interested if it was a dumb idea )
I li...
Why wouldn't you consider it? I agree that you couldn't do this as a part of the primary refactoring, since it could remove wanted blank lines, but it could just be a seperate menu item that says remove double blank lines (particularly for a selection.)
I do understand and either way, thanks for the tip with regular expressions [image] / comments
Why wouldn't you consider it? I agree that you couldn't do this as a part of the primary refactoring, since it could remove wanted blank lines, but it could just be a seperate menu item that says ...