SQL Server Compact 3.5 SP1 can be installed using one of the following methods: As part of SQL Server 2008 installation. As part of installing Visual Studio 2008 or later versions. Downloading it from the Microsoft downloads site. For further information refer to Installing SQL Server Compact topic in SQL Server 2008 Books Online. Individualjnij marshrut razvitiya rebenka s ovz v dou obrazec.

Hi I am developing a database application for smart devices using VS2005 and SQL Compact 3.5 Compact SP2 I am tring to get the first record in a table named Customer2 and I tried many techniques for that I tried to use FIRST() function, TOP, and MIN() function and failed to get it Here is my query using MIN: SELECT [Customer Name], [Account Reference], House, [Meter No.], [Plate No.], Address FROM Customer2 WHERE ([Customer ID] = (SELECT MIN([Customer ID]) AS EXPR1 FROM Customer2 Customer2_1)) I hope expertise correct me if I missed something Thank you very much.

Just want to find out if anyone has used or is currently using Sql Compact 4.0 for development. Basically we are looking for tools that can support the creation of change script similar to the one we have in Sql Server 2008 Management Studio. If you are not sure what that feature is, basically whenever you make schema changes, you can simply generate the change script to be run elsewhere. I haven't come across any tools that can provide that kind of feature for Sql Compact 4.0. Has anyone come across that kind of tool?

If so, can you please let me know? Thanks in advance.