| Author |
Message |
robvon
Joined: 30 Dec 2008
Posts: 4
|
 Posted: Thu Jun 04, 2009 2:34 am Post subject: Qualify Object Names |
 |
|
Generates: SELECT TableName.[*].... out of SELECT *....
The [*] is a syntax error. Should be just '*' |
|
| Back to top |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Thu Jun 04, 2009 9:39 am Post subject: |
|
|
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: support@red-gate.com |
|
| Back to top |
|
|
MartinB
Joined: 04 Sep 2009
Posts: 5
|
| Posted: Thu Sep 10, 2009 8:02 am Post subject: |
|
|
I too have this problem
It only happens when you do a join to another table
e.g.
| Code: |
Select * from member
|
is Ok but
| Code: |
SELECT
m.*
FROM
Member m
inner JOIN Party p
ON m.PartyID = p.PartyID
|
becomes (when you qualify it)
| Code: |
SELECT
m.[*]
FROM
dbo.Member m
inner JOIN dbo.Party p
ON m.PartyID = p.PartyID
|
|
|
| Back to top |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Thu Sep 10, 2009 10:44 am Post subject: |
|
|
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: support@red-gate.com |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
