The lengths I go to when performing Visual Studio updates only seem odd to the uninitiated.
I’ve been burned so many times applying simple patches to Visual Studio or trying out Beta framework extensions that I now do a full disk image before I update VS.
Today I’m applying Microsoft Visual Studio 2008 Service Pack 1 (Installer)
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
Posted
Sep 10 2008, 01:26 PM
by
DerekMitchell