Competition: What’s your favorite Redgate tool? Enter now.

Qualify Object Names

robvonrobvon Posts: 7
edited September 10, 2009 5:44AM in SQL Refactor Previous Versions
Generates: SELECT TableName.[*].... out of SELECT *....

The [*] is a syntax error. Should be just '*'

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    Could you kindly let us know the steps to replicate this issue and also using which functionality of SQL Refactor generates this error?

    Please make a note that above details will help us to investigate further.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • I too have this problem
    It only happens when you do a join to another table

    e.g.
    Select * from member 
    
    is Ok but
    SELECT
        m.*
    FROM
        Member m
    inner JOIN Party p
    ON  m.PartyID = p.PartyID
    
    becomes (when you qualify it)
    SELECT
        m.[*]
    FROM
        dbo.Member m
    inner JOIN dbo.Party p
    ON  m.PartyID = p.PartyID
    
  • Thanks for your post and apologies for the inconvenience caused by this issue.

    We have logged this issue in our internal tracking system [SR- 846] and will be addressed in our future release.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.