Posts
Sort by recent activity
Non highlighted text is being syntax checked:
The following is the batch:
Check this out:
select *
from bob --a table I have created
select *
from bob
I highlight only one of the select * from bob and the following error is raised:
Documen...
CTP Expired Message
I uninstalled the previous version, installed the new version, restarted SSMS, went over the options (which look pretty nice, I might add) and then clicked "Lay Out SQL". This is the message:
SQL ...
extra linefeed/carriage return characters
Need to remove extra linefeed/carriage return characters. Often a script comes from Outlook or the newsgroups with extra lines like:
SELECT column
FROM table
WHERE a=b
AND c=d
And this is rea...
Must become less intrusive
I think that the problem I am having with the tool in general is when I am not using it, it becomes a real annoyance, and none of the activation keys can be used in normal coding.
The window poppin...
Joins should only include reasonable columns
If I join
tableA
join tableB
on <-- the list pops up again
This list should only contain columns from tableA and or tableB. And it should prefer a foreign key that the table shares, a column they...
Need to filter objects on schema name
If I type:
select *
from schemaName.
The list needs to be filtered to only objects in that schema, otherwise I still have to hunt through tons of objects (including sys. objects, which was what ...
Schema name displayed in the prompt list
Schema name needs to show in the list. I have databases with several schemas, and right now even the sys. objects show in the list and things get jumbled
A toggle to show or not show could be good ...
Problems with duplicate object name in different schema
--in tempdb, I created the following objects (the refactor tool added the
--brackets, which I would prefer not to see
create schema bob
go
create schema bob2
go
create table [bob].[tableName]
(
co...
Shouldn't qualify names of objects that you cannot find.
For example, if I go to the master databse and put:
select *
from product
it changes it to:
select *
from [dbo].[product]
Neither of which will work. Also, in adventureWorks, if I say qualify nam...
Bug with LayOut SQL.
The following error:
Document Contains Invalid SQL Syntax
SQL Refactor was unable to lay out this file because some errors were found while it was being parsed. These errors have been highlighted....