Refactoring an INSERT statement into an UPDATE statement - does it do "select" instead of "values"?

dsm1

I know that you can refactor an "insert into xxx values ()". But, is it possible to do the same on a select i.e. "insert into xxx select from"?

Dan_J

Hi @dsm1

Thanks for reaching out to us regarding this.

Having attempted this with SQL Prompt and looking through our articles in relation to refactoring, unfortunately it does not currently appear possible to do this.

Please feel free to log a request for this on our uservoice forum: https://redgate.uservoice.com/forums/94413-sql-prompt