SQL Prompt sometimes works on some parts, e.g., it will give a list of columns for MATCHED but only for the TARGET table, never the source... It also suggest tables when coding a list of columns for an INSERT or it quits making any suggestions at all. This is a very hit-and-miss situation and very frustrating.
As the MERGE statement has been around since SQL Server 2008, it's very surprising/disappointing that, considering MERGE to be a STANDARD part of the DB Engine, SQL Prompt is this far out of date... FOUR YEARS AND COUNTING...!
Please "get current" :-)
We’ve improved MERGE statement suggestions in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
Please let us know if you have any examples where you think suggestions could be improved!