Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Row types and constructors (SQL99 features T051, F641)

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.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    unplanned  ·  AdminMicrosoft SQL Server (Admin, Microsoft Azure) responded  · 

    Upvotes: 9

    <=-=Dec 7 2007 7:54AM=-=>

    Hello,

    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.:

    INSERT INTO contacts VALUES
    (‘John Doe’, ‘425-333-5321’),
    (‘Jane Doe’, ‘206-123-4567’),
    (‘John Smith’, ‘650-434-7869’);

    Cheers,
    -Isaac

    <=-=Apr 5 2010 4:49PM=-=>

    Hi,
    Thanks for your feedback. I have resolved your request as duplicate of feedback item below:

    https://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=299231


    Umachandar, SQL Programmability Team

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base