Posted inSQL
Microsoft
5 years ago
TSQL Expand OUTPUT clause functionality
Many developers rely on the INSERT ONLY form of MERGE to gather data because OUTPUT with MERGE is the only OUTUT clause that supports gathering fields from other tables in the query besides Inserted and Deleted objects. If OUTPUT was improved to allow this functionality with INSERT/UPDATE/DELETE we could stop using MERGE for good!
New
ProgrammabilitySuggestionsNew
Vote
0 Comments