Skip to content

How can we improve SQL Prompt?

SQL Prompt: Intellisense

CATEGORIES
All ideas
My feedback
Code Analysis 48 ideas
Encapsulate as new stored procedure 1 idea
Expand wildcards 7 ideas
Find invalid objects 7 ideas
Find unused variables 3 ideas
Format SQL 187 ideas
Intellisense 77 ideas
Platform Support 16 ideas
Qualify object names 6 ideas
Script object as alter 14 ideas
Smart rename 10 ideas
Summarize script 5 ideas
Tab coloring 5 ideas
Tab history 42 ideas
User interface 88 ideas

Searching…

No results.
Clear search results

- Flyway 15 ideas
- MySQL tools 24 ideas
- Oracle 129 ideas
- Redgate 0 ideas
- SQL Change Automation 50 ideas
- SQL Compare 249 ideas
- SQL Data Compare 110 ideas
- SQL Prompt 663 ideas
- SQL Search 133 ideas
- SQL Source Control 588 ideas
- SQL Toolbelt Essentials 16 ideas
Redgate

CTE Support

It would be nice if SQL Prompt could parse CTE expressions and provide prompts just like for regular tables

14 votes

Rad! shared this idea · Aug 15, 2011 · Report… · Admin →

completed ·

Justin Caldicott responded · Mar 19, 2012

This issue has been reported non-reproducable in recent versions of SQL Prompt.

An error occurred while saving the comment

John Unger commented · June 13, 2014 9:03 AM · Report

This happens to me all of the time. Simple procs and views are fine but probably once a week I find that the expansion just stops working or worse starts putting in system objects instead of providing the prompt for the fields available in an alias. Let me know if you want me to do some screen sharing with someone to duplicate this issue.

Submitting...
AdminPaul Stephenson (Admin, Redgate) commented · August 16, 2011 1:37 AM · Report

Hi Rad! CTEs are meant to be supported. Could you give an example where it fails for you?

Submitting...