SQL Server Compact 3.5 Features

re: SQL Server Compact 3.5 Features

Anne — Tue, 07 Oct 2008 20:57:11 GMT

is this SQL is supported in the version of SQLCE

select i.ID, (Select Sum(Amt) from t2 p where p.ID = i.ID) as UnpaidAmt from t1 i

Thanks.

re: SQL Server Compact 3.5 Features

Dave Michel — Tue, 05 Aug 2008 01:26:28 GMT

Any examples of how to do a subquery in the FROM clause (or any other clause) in CE 3.5 RTM? I can only get a WHERE IN to work.

:-(

re: SQL Server Compact 3.5 Features

Steve Lasker -MS — Mon, 19 Nov 2007 15:05:42 GMT

Hi Kettch,

Yes, sub queries in the FROM clause are in RTM.

Steve

re: SQL Server Compact 3.5 Features

kettch — Fri, 16 Nov 2007 10:31:56 GMT

"Looks like Sub Query didn't make Beta 2. RTM is just around the corner, so just hang in there just a little bit longer..."

Just to be clear, subqueries *will* be in RTM?

re: SQL Server Compact 3.5 Features

Steve Lasker -MS — Fri, 09 Nov 2007 16:17:41 GMT

Hi Ilan

We have had some issues with corruption when multiple processes open the same database and one of the processes dies. This gets worse in Visual Studio when we kill debugging during an app update.

We've done a number of fixes in 3.5 to minimize this and while we can never gaurentee corruption won't happen, we're seeing many of the historical problems are soved. It would be great to download 3.5, give it a try, and let us know. If your still having trouble, we want to know so we can fix the unique situations we're not seeing.

BTW, RTM is just a few weeks away...

Steve

re: SQL Server Compact 3.5 Features

Ilan — Thu, 08 Nov 2007 14:07:56 GMT

I have a memory corruption error from time to time and its not the ntext field problem are you familiar with this issue ?

re: SQL Server Compact 3.5 Features

Steve Lasker -MS — Tue, 30 Oct 2007 06:45:48 GMT

Looks like Sub Query didn't make Beta 2. RTM is just around the corner, so just hang in there just a little bit longer...

Steve

re: SQL Server Compact 3.5 Features

Dave Michel — Thu, 18 Oct 2007 21:55:38 GMT

I'm working with 3.5 Beta 2, and am finding that a subquery in a SELECT clause still doesn't seem to be supported. Am I wrong, or is this functionality still not part of CE 3.5 Beta 2?

re: SQL Server Compact 3.5 Features

MikeH — Fri, 31 Aug 2007 15:56:37 GMT

Will ADO.NET EDM Beta 2 support SQLCE 3.5?