Does SqlCE support nested query?
I had tried something very simple like Selete * From (Select ID, Name from
MyTbl) as tbl
whithout any good results

I am a Newbie about SQL Server CE.
I wonder whether the local SQL CE database is essential to SQL Server
CE-base application?
Can we develop an CE-base application operating remote SQL Server 2000

I'm developing in VS.net 2003 a windows application that has access to a
SQLServer CE Database in my Windows CE.net. when using DataTables and
Databinds to controls, everything works fine, but when using a DataReader
(SqlCeDataReader) throws this kind of exception. (Finally by ...

I want to change rows and update back to the data source in PPC2003 ,
and the code i used below are from O'Relly Book Excerpts: Programming Visual
Basic.NET , ADO.NET, part 1-4 .
But when i use the code and modified it in my application ,when run it on my

when we r connecting database in poket pc application we have to run
replication synchronize. so could u tell me what i have to give as
subscriber. my sql server client and sql server ce and iis are on same
machine. but the sql server Server is at another machine.

while i m running my pocket pc application. when i m synchronize the
replication its giving an error :
   initializing Sql Server Reconciler Has Failed
can u guide me about this.

We are using the OLEDB interface to SQLCE.   During some conditions in
running the App the Database has to be "Closed" and then "Re-Open".  This is
done by >Release() of all the interfaces and then:
           m_pIDBInitialize->Uninitialize();

I need to know whether a table is empty or not. If it is not empty it
will contain a few thousand rows. What's the best way to work it out?

Can anybody give me an explanation how to save a pdf-file in a Sql Server Ce
database?
thx
robert

The documentation for the SqlCeCommand.Prepare method states that
"Before you call Prepare, specify the data type of each parameter in the
statement to be prepared. For each parameter that has a variable-length data
type, you must set the Size property to the maximum size needed. ...

System: (and installation order)
Server 2003 Standard
SQL 2000 SP3
SQL CE 2.0 (from sqlce20sql2ksp3a.exe)

Ok, I have several devices performing merge replication.  It's been in the
field for a couple months now, but have developed an issue at one location.
Over the course of a single day I set up 3 devices.  Created local .sdf
files, and merged info from remote server.   Checked web ...

I've been trying for hours and hours....  the installation of SSCE says it
completes succesfully - yet - I do not have the option to include
System.Data.SqlServerCE in any of my .Net code.
I have tried making local references, copying local, adding to the GAC,

In attempting to run a relatively complex union statement I came across the
following error :
'The ntext and image data types cannot be used in WHERE ,HAVING,GROUP By,ON,
or IN clauses , except when these data types are used with the LIKE or IS

I am receiving the following error when trying to insert a
record into a table:
"A duplicate value cannot be inserted into a unique index"
I have checked the values I am attempting to insert and