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

Support row constructors for conditional expressions

Supporting ANSI row constructors would:
a) simplify many T-SQL statements
b) speed up development
c) help port code from Oracle to SQL :-)

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

    We’ll send you updates on this idea

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

    Upvotes: 44

    <=-=Mar 27 2006 1:56PM=-=>

    Thank you for your feedback. We’re certainly considering row constructors for a future release of SQL Server. The number of votes on this item is also a useful indication to us.

    - Christian Kleinerman

    <=-=May 31 2006 9:09AM=-=>

    Note: support for row contructors in UPDATE statements is, of course, also valuable. It provides a valuable alternative UPDATE syntax and it helps when porting from Oracle ;)

    <=-=Apr 5 2010 2:54PM=-=>

    Hi,
    I have resolved this item as duplicate of below:

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299231&wa=wsignin1.0#

    Thanks
    Umachandar, SQL Programmability Team

    0 comments

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

      Feedback and Knowledge Base