Ability to generate SELECT test script from an UPDATE statement
When debugging an UPDATE statement, it would be handy if SQL Prompt could generate a test Select script that converts
UPDATE xxxxxx
SET SalesPeriod = dddddd,
SalesYear = yyyy,
CustomerCode = zzzzz
...
into
SELECT dddddd as SalesPeriod,
yyyy as SalesYear,
zzzzz as CustomerCode
....
Optionally, could include all columns involved in joins or WHERE clauses
11
votes
Mike Gordon
shared this idea