Microsoft released SQL Server CE 2.0
Microsoft SQL Server 2000 Windows® CE (SQL Server CE) version 2.0 provides enhanced database engine and query capabilities, improved connectivity solutions, and is integrated with the Microsoft Visual Studio® .NET and the Microsoft .NET Compact Framework. (9/18/2002)
Microsoft SQL Server 2000 Windows® CE (SQL Server CE) version 2.0 provides enhanced database engine and query capabilities, improved connectivity solutions, and is integrated with the Microsoft Visual Studio® .NET and the Microsoft .NET Compact Framework. SQL Server CE 2.0 includes updates to:
Query analyzer. The query analyzer has been updated to improve the user interface for easier object management.
- Query processor. The query processor enables you to streamline your code with new intrinsic functions and parameterized queries.
- Storage engine. The storage engine includes major improvements to remote data access functionality, including index pulls and UPLOAD-only features. In addition, the storage engine now supports the same number of indexes (249) per table as Microsoft SQL Server.
- Connectivity wizards. This step-by-step guide can help you quickly set up your security and connectivity options for data replication.
- ISQLW. This on-device query tool enables you to store queries and view the schema on the device.
These features provide a better experience, increased engine performance, and added SQL Server functionality. SQL Server CE 2.0 provides both developers and database administrators the best database to build mobile extensions for their enterprise business applications.