How can we help you today? How can we help you today?

Learn prompt your naming convetions?

Hi,

Great tool and its the first sql intellisense product that does what I want :)

Well, almost cause I got excited when I saw the feature "TAbles join by matching column names". Problem is a lot of the database I work with add a prefix (or suffix) to the column in the child table. For example

SELECT * FROM
Manager inner join Employee
WHERE
Manager.ManagerID = Employee.ManagerIDR

--> an R gets added to MangerID to make the column names in the reslut set unique.

Is such a feature being considered?

And while Im at it I think it would improve readability if the query gets formatted on multple lines. For example :

SELECT * FROM Manager where Name = 'test' ORDER BY Name

would become :
SELECT
    col1,col2,col3,col4 
FROM 
     Manager 
WHERE
     Name = 'test' 
ORDER BY 
     Name

Especialy for large queries this would be handy

Thx for your consideration,

Tom
buckley
0

Comments

3 comments

Sort by
  • xero
    Yeah great tool like buckey said, but I was also wondering if it is possible to build in some automatic formatting options like indentation.
    xero
    0
  • ChrisRickard
    Yes, auto indentation for those editors that don't do it would be wonderful.
    ChrisRickard
    0
  • Bart Read
    Hi Tom,


    Thanks for your feedback and kind words about the product. That's an interesting suggestion. I think what would probably be the smart thing to do under these circumstances is some sort of slightly more intelligent matching whereby it would look at matching data types, identity columns etc, and then display these options in the list below the more "obvious" options. My feeling at the moment is that the Options dialog already has *way* too many options in it, and that many of them are there to workaround shortcomings in the current version of the tool... not that I don't think it's a good tool, but it's only the first version. I think if we make the parsing model in particular much more robust then the need for many of these options will disappear, or at least that's what I'm hoping.

    The other thing with this is that if there's an actual foreign key relationship then the JOIN should work regardless of what the columns are called, but at the moment I'm not so sure what happens under these circumstances.

    Anyway, version 3 should be available sometime in September all being well, so keep your eyes peeled for announcments here and on the Red Gate website.


    Many thanks,
    Bart Read
    0

Add comment

Please sign in to leave a comment.