Comments
Sort by recent activity
From the "SQL Prompt" menu at the top of your editor click "Cache Management" / comments
From the "SQL Prompt" menu at the top of your editor click "Cache Management"
Yes it is checked / comments
Yes it is checked
Oh and notice the line
INNER JOIN tblPagePanel PP ON (P.nPageID = PP.nPageID)nPageID)
the "nPageID)" was added by SQLPrompt because the candidate list opened when I typed the closing parentheses. I then hit the Enter key to go to the next line and SQLPrompt inserted the first item in the now open candidate list which was "nPageID". / comments
Oh and notice the line
INNER JOIN tblPagePanel PP ON (P.nPageID = PP.nPageID)nPageID)
the "nPageID)" was added by SQLPrompt because the candidate list opened when I typed the closing parentheses. I...
Another one.
I now have the auto complete parentheses turned off so I type
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (
and the correct join options appear, however when I select my join from the candidate list and add the closing parentheses manually the candidate list reappears with a list of columns from tblTime not allowing me to hit "Enter" to go to the next line without first hiting the "Esc" key to close the candidate list. / comments
Another one.
I now have the auto complete parentheses turned off so I type
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (
and the correct join options appear, however when I select my join fr...
Here is the problem... Everything works the way I would expect it to "IF" I do not use an opening parentheses. So in the example
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON
The first item in the candidate list is R.nRequestID = T.nRequestID
However if I use an opening parentheses AND have the option to automatically close parentheses (SQL Prompt > Auto Insert > Automatic Closing Characters), all of this functionality is out the door. I did notice that by default Parentheses was not checked in this section. Is this a known issue? / comments
Here is the problem... Everything works the way I would expect it to "IF" I do not use an opening parentheses. So in the example
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON
The first item in...
When typing:
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (R.nRequestID = T.
I would think that I would only get items in the candidate list that matched either by foriegn keys or at the least by datatype. I know its possible to join on two different datatypes but it is not best practices. / comments
When typing:
SELECT *
FROM tblRequest R
INNER JOIN tblTime T ON (R.nRequestID = T.
I would think that I would only get items in the candidate list that matched either by foriegn keys or at the leas...
OS: Windows XP Pro SP2
Framework: ??? .NET?? 1.1 & 2.0
CPU: P4 3.6 GHz
RAM: 1 GB
Editors: SQL Server Management Studio (2005) and SQL Query Analyzer 2000.
I just tested both and right now I am just getting the pop-up with the "Messages". Previously I was getting several different items that it was cataloging that were taking the most time. The "Messages" takes about 5 - 10 seconds.
Also, we have a couple of fairly large databases on these server of 12GB + with thousands of objects (views, tables, procedures, functions, triggers, etc...)
John W. / comments
OS: Windows XP Pro SP2
Framework: ??? .NET?? 1.1 & 2.0
CPU: P4 3.6 GHz
RAM: 1 GB
Editors: SQL Server Management Studio (2005) and SQL Query Analyzer 2000.
I just tested both and right now I am just...