Are we to expect support for Row Constructors beside what is in the current CTP (i.e. beside what is shown for INSERT?
Examples:
Select *
From MyTable
Where (a,b) in (Select a,b From OtherTable...);
or
Update MyTable
Set (a, b, c, d) = (SELECT a, b, c, d From OtherTable ....)
Where ...;
thanks
No. Use of row constructors in predicates and UPDATE will not be in Katmai. -- Umachandar Jayachandran Microsoft SQL Server Performance Team SQL Server Engine Team Tips Blog at http://blogs.msdn.com/sqltips/default.aspx SQL Server Performance Engineering Team Tips Blog at http://blogs.msdn.com/sqlperf/default.aspx This posting is provided "AS IS" with no warranties, and confers no rights. "Lakusha"@.discussions.microsoft.com wrote on Thu, 12 Jul 2007 07:06:02 -0700: L> Are we to expect support for Row Constructors beside what is in the L> current CTP (i.e. beside what is shown for INSERT? L> Examples: L> Select * L> From MyTable L> Where (a,b) in (Select a,b From OtherTable...); L> or L> Update MyTable L> Set (a, b, c, d) = (SELECT a, b, c, d From OtherTable ....) L> Where ...; L> thanks