Below is a table with a few Code complete questions and comments. (Some could be
bugs) More will be sent later this week. Just getting going with the new beta…
Please remember, my job now is not necessarily being a SQL programmer, except
when there are strange issues. Such is the life of a SS DBA/Archtitect.
Senior Systems, Database/Data Warehouse Architect
678-414-0090 my cell Primary
Please advise when typing in the shown statement the built in function list is
displayed… What is needed here is nothing at all for this is a select * into
statement being constructed.
The Editor should not show the functions list after you type in a schema name of
dbo… This does not happen if you type in hfdbo. Which does not exist.
If this was a select * Into and the next character is an ‘@’ then
the list to the left in the graphic would be valid and useful.
As you can see the second example when you perform a Select * into #HF_test
followed by a space you get the function list AGAIN.
Therefore, I consider this nuisance as such and a BUG !!!
When working with Code Complete to find issues with simple select statements.
Toad-SS goes into a loop that completely takes over the I5-quad core CPU.
Code complete is still a very large issue when trying to use it with simple
statements as seen in the graphic to the left.
I was never able to complete the statement because of the Toad-SS Beta program
issue (looping is suspected)
The means to correct the problem was to shutdown Toad-SS. This should be
relatively easy to reproduce since I could easily do it again and again.
Therefore, No Support Bundle supplied.
While editing an Update statement Code Complete displays the options as seen in
the graph. When all I was trying to do was drop and drag a table from the Object
This level of functionality is not fully understood, could this be explained why
I get the options, when I do not need it.
Seems to be a timing issue for it doesn’t happen all the time, but it does
happen … Granted the fully qualified database name need to be in [ ], but I
wanted the system to find that error, which it did. Sooo, that may be the reason
for the error.