SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Temp and linked tables

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Temp and linked tables
Author Message
DarylPrice



Joined: 13 Feb 2008
Posts: 4
Country: United States

Post Temp and linked tables Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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
Design by Freestyle XL / Flowers Online.