SQL Server Compact 3.5 runs side-by-side with SQL Server 2005 Compact Edition (3.0/3.1).
Notice the name change, again ;)
SQL Server 3.5 contains some enhancements such as:
- Timestamp datatype - at last! ;)
- Transact-SQL enhancements such as:
- Nested query in FROM clause
- CROSS APPLY and OUTTER APPLY
- CASE and DECIMAL
- SET IDENTITY INSERT
Read about all the new features here.
This release is supported on Pocket PC 2003 as well as the later devices, WM5, WM6.