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
  • 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: 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
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base