Many new data-related features will be enhanced in Europa, including the addition of support for new data types such as variable character, variable binary, and blob types for increased compatibility with SQL Server 2000 and the upcoming version of SQL Server, code-named "Yukon." Support for subqueries is just one of many new enhancements to the SQL language in Europa, such as the ability to execute the following: SELECT * FROM foo t1 WHERE f1 IN (SELECT f1 FROM foo).
|