 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
DarylPrice
Joined: 13 Feb 2008 Posts: 4 Country: United States |
|
Temp and linked tables |
|
Just a couple of things to look at in the future. When using the select statement to view the contents of a temporary table and when SQL Assistant displays all of the columns to view automatically it leaves a comma after the last field which causes it to fail.
It would be nice to have linked tables to work i.e. select * from ONYX..reporter. After the two dots nothing occurs after that.
Thanks,
[/b]
|
|
Wed Feb 13, 2008 12:57 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you for your suggestions. Would you please describe in more detail what you meant by "When using the select statement to view the contents of a temporary table and when SQL Assistant displays all of the columns to view automatically it leaves a comma after the last field which causes it to fail?" Can you provide a specific example?
As for the linked servers, we are not planning on supporting them in the current version. Linked servers/tables can very easily crash the server if connection is broken and something goes wrong. They can also cause serious performance issues which can make the SQL Intellisense really unusable for such tables.
|
|
Wed Feb 13, 2008 1:19 pm |
|
 |
|
|
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
|
|
|