SQL Server CE 2.0 Released

By Bill Graziano on 17 September 2002 | Tags: SQL for CE

Microsoft released SQL Server CE 2.0. 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.

Link: SQL Server CE 2.0 Released

Related Articles

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices (msdn) (15 May 2001)

Good Things in Small Packages: Microsoft Launches SQL Server 2000 for Windows CE (28 November 2000)

Other Recent Forum Posts

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0xfffffffe). It occurred during a read of page (1:908) in database ID 99 at offset (111m)

Case stmt in SSIS (19h)

Upgrading from MSSQL 2016 to 2017 (1d)

Why does CASE WHEN NULL IN (SELECT A FROM B) THEN 'Y' ELSE '' AS [NULL] does not work? (1d)

Tensorflow package installation on SQL 2019 ML Services (1d)

How can I reference the table (T1 JOIN T2 ON A=B JOIN T3 ON C=D)? (1d)

Is there an easy way to populate a column with an INDEX/MATCH statement? (2d)

Is joining table completely deceiving? (2d)

- Advertisement -