Home Dashboard Directory Help
Search

Output cluase Enhancement by John-Huang


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Suggestion
ID: 766123
Opened: 10/4/2012 10:11:40 AM
Access Restriction: Public
0
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft on 10/9/2012 at 4:54 PM
Hello,
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
Sign in to post a workaround.