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.
Upvotes: 9<=-=Dec 7 2007 7:54AM=-=>
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’);
Thanks for your feedback. I have resolved your request as duplicate of feedback item below:
Umachandar, SQL Programmability Team