Output cluase Enhancement - by John-Huang

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 766123 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/4/2012 10:11:40 AM
Access Restriction Public


It would simplify the T-SQL programming on "stream processing" if output clause can support multi outputs, filters, output to procedures, or output to tables or views with trigger enabled.
Sign in to post a comment.
Posted by Microsoft on 10/9/2012 at 4:54 PM
Thanks for your feedback. You are asking for a feature called "Data Change Delta Table" that is specified in the ANSI SQL standard. This allows you to use any data change operation as table source and compose queries in a general manner than what we have. DB2 has an implementation of that feature.
We will re-evaluate your request in the future if we hear more from customers. Right now we have lot of higher priority requests in our pipeline and this will not make it to the top of the list so I am closing it as "won't fix" for now.

Umachandar, SQL Programmability Team