Row types and constructors (SQL99 features T051, F641) - by Mark Yudkin

Status : 


Sign in
to vote
ID 262284 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 3/8/2007 1:43:31 AM
Access Restriction Public
Primary Feedback Item 299231


ANS SQL 99 feature T051 defines row types, including row value expressions. The related F641 specifies row and table constructors.

Please add support for these ANS SQL 99 features T051 and F641.

Row types and expressions considerable simplify certain types of queries. In addition, this feature is frequently met in SQL written for other databases, so that migration to SQL Server is made unnecessarily complicated. 

I acknowledge that the MS extension of permitting a FROM in an UPDATE serves as a work-around for the lack of row values in updates; but the ability to use ANS-conformant syntax rather than an MS extension would assist portability.
Sign in to post a comment.
Posted by Microsoft on 4/5/2010 at 4:49 PM
Thanks for your feedback. I have resolved your request as duplicate of feedback item below:

Umachandar, SQL Programmability Team
Posted by Microsoft on 12/7/2007 at 7:54 AM

Thanks for submitting this---apologies for the delayed response.

It looks like this was considered for the current release, but didn't make it due to resource constraints. We are keeping this issue around because we would like to do this.

FWIW, we have added some limited abilities in this area, allowing multi-row insert statements. E.g.:

    ('John Doe', '425-333-5321'),
    ('Jane Doe', '206-123-4567'),
    ('John Smith', '650-434-7869');