and

Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobile

SQL Server Compact 3.5 Service Pack 1 for Windows Mobile is not included in VS 2008 SP1, but it looks like SQL CE 3.5 SP1 for the desktop is included.

I think there is going to be a lot of confusion about this, if you look carefully at the screen grab on the left, you can see the dialog only mentions SQL Server Compact 3.5 SP1 – there’s no desktop or devices distinction.

Why update to SQL Compact Edition 3.5 SP1?

I’m doing it solely for the new Transact SQL support for:

• Nested query in FROM clause
• CROSS APPLY and OUTER APPLY
• CAST
• TOP
• SET IDENTITY INSERT

Here are the 3.5 SP1 release notes with information about the other SP1 enhancements/fixes.

Other important SQL Server Compact Edition URLs

• Microsoft SQL Server Compact 3.5 Server Tools
• Microsoft SQL Server Compact 3.5 Service Pack 1 Books Online and Samples
• Description of the various build versions of SQL Server Compact Edition – doesn’t show beta versions
• SQL Server Compact Release Versions – does show beta versions