Welcome to MSDN Blogs Sign in | Join | Help

SQL Server Compact 3.5 Features

Ambrish, one of our great Program Managers for SQL Server Compact has posted some details on the 3.5 enhancements:

http://blogs.msdn.com/sqlservercompact/archive/2007/08/30/sql-server-compact-3-5-beta-2-downloads.aspx?CommentPosted=true#commentmessage

Steve

Published Thursday, August 30, 2007 4:56 PM by Steve.Lasker

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: SQL Server Compact 3.5 Features

Friday, August 31, 2007 8:56 AM by MikeH

Will ADO.NET EDM Beta 2 support SQLCE 3.5?

# re: SQL Server Compact 3.5 Features

Thursday, October 18, 2007 2:55 PM by Dave Michel

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

Monday, October 29, 2007 11:45 PM by Steve.Lasker

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

Thursday, November 08, 2007 6:07 AM by Ilan

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

Friday, November 09, 2007 8:17 AM by Steve.Lasker

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

Friday, November 16, 2007 2:31 AM by kettch

"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

Monday, November 19, 2007 7:05 AM by Steve.Lasker

Hi Kettch,

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

Steve

# re: SQL Server Compact 3.5 Features

Monday, August 04, 2008 6:26 PM by Dave Michel

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

Tuesday, October 07, 2008 1:57 PM by Anne

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.

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker