Skip to content

How can we improve SQL Prompt?

SQL Prompt: Format SQL

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 186 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 89 ideas

Searching…

No results.
Clear search results

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

Refactoring an INSERT statement into an UPDATE statement with SELECT

Be able to refactor INSERT statement into UPDATE statement that has SELECT rather than VALUES i.e. "insert into xxx select from".

2 votes

Alvin shared this idea · Sep 30, 2021 · Report… · Admin →

An error occurred while saving the comment

Jeff Humphreys commented · February 20, 2022 12:12 PM · Report

This really needs a visual. I don't see where it becomes an update.

Submitting...