Posts
Sort by recent activity
No Join Expression
I'm using the 3.6 release of SQL Prompt and in some cases I'm not getting a join suggestion when I think I should be.
Here is an example:
select distinct tx_id
into [TX_IDs WITH Problems 9-24-07]
f...
Multiple selections from suggestions on join?
It would be nice if you could select multiple suggestions to be inserted when building a join. This could done by either holding shift and pressing the down arrow, or by holding ctrl and clicking o...
Temp tables from Oracle linked server
I know linked Oracle servers aren't supported, but given the sample code below, would it be possible to at least support the temp table object itself, and maybe the field names that are selected?
S...
New 3.6 feature does not honor formatting options
If you have your formatting options set to not add [] around candidates, but you type this code:
select * into #test from MASTER.dbo.spt_values;
select * from #<cursor>
At the cursor a suggestion p...
No join suggestions
I have the option turned on in SQL Prompt 3.6 EA to suggest joins based on field names, but when writing this query:
SELECT
tdl_id
FROM edic_cga_details d
INNER JOIN (SELECT tx_id, SUM(amount) as a...
Auto complete in field list portion of SELECT
I just wanted to check and see how the auto complete is intended to work in the field list portion of a SELECT statement.
Given this query:
SELECT DISTINCT
tdl_id<cursor1>
INTO #test
FROM edic_cga_...
Temporary table support in 3.6 EA
I'm sure I just don't know how it is supposed to work, or how to use it, but I don't see temporary table support working.
Here is an example:
SELECT DISTINCT
tdl_id,
post_date
INTO #test
FROM edic_...
No or wrong suggestions in some circumstances
I have some code that must confuse SQL Prompt 3.6 EA:
INSERT INTO dbo.edic_cga_details
SELECT
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.tdl_id,
t.t...
Roaming Profiles and SQL Prompt options
We recently purchased SQL Prompt 3, and have now noticed that we loose all of our settings every time we log off our PC. Our PCs are setup with roaming profiles, which I suspect are the problem, si...
SQL 2000 and 6.5 compatible DBs?
I am evaluating SQL Prompt 3, and when connecting to a SQL 2000 server, and selecting a DB that is in 6.5 compatibility mode I get this error:
SQL Prompt could not retrieve the database schema:
<db...