Comments
Sort by recent activity
I think I might have some good news here for all of you Smile http://www.red-gate.com/MessageBoard/vi ... php?t=9517
Hi everyone
I have the same problem with column order in temptables.
Downloaded and installed the new version (SQL Prompt 4 Standard build 4.0.2.53).
But it does not change a thing. It works fine with physical tables but not with temptables:
CREATE TABLE #t1 (f1 INT, f2 INT, s1 VARCHAR(20), s2 VARCHAR(20), b1 BIT, b2 BIT)
SELECT * (tab afterwards)
FROM #t1
There is another problem with temptable definitions that the column order changes in the suggestionswindow. That is, in the "All suggestions" tab it is different to the "column picker" tab both when checking "List in table order" or unchecking it (btw: when checking "list in table order" it does indeed a re-sorting, but NOT in table order at all). / comments
I think I might have some good news here for all of you Smilehttp://www.red-gate.com/MessageBoard/vi ... php?t=9517
Hi everyone
I have the same problem with column order in temptables.
Downloa...
This feature would certainly be necessary. Especially in databases with moderate to high complexity where interdependency between tables is daily business.
The absence of the feature is one reason why the application is not in use here. / comments
This feature would certainly be necessary. Especially in databases with moderate to high complexity where interdependency between tables is daily business.
The absence of the feature is one reason ...
Hi
Thought that other users might have had some of the same ideas.
Regarding the last two suggestions:
-Automatic execution of snippets: yes, I mean without opening the candidate list.
-Alias mystery solved:
1 I defined in the options window, Alias tab the following: dbo.tblArtBasis with an alias ab. When I typed something like SELECT * FROM tblArtBas... it made the alias as tab.
No I defined the alias without dbo. only tblArtBasis and it seems to work. http://www.red-gate.com/MessageBoard/viewtopic.php?t=3835
does not give an answer on the Date-Placeholder.
Cheers / comments
Hi
Thought that other users might have had some of the same ideas.
Regarding the last two suggestions:
-Automatic execution of snippets: yes, I mean without opening the candidate list.
-Alias myste...