SQL Language limitations in SQL CE

[Vitaly Sedov]

Hello!

Is somebody knows where can I found information about SQL Language
limitations in SQL CE?
I wrote query with subquery that works fine on desktop SQL Server 2000, but
it's not working in SQL CE

Vitaly

 

[Sergey Bogdanov]

Well, all information is available in MSDN. See SELECT Statement
description:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_select_statement.asp

Also take a look at "SQL Server CE Books Online":
....Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows
CE\sqlce.chm



Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com

 

[Vitaly Sedov]

Thank you, Sergey!

Well, all information is available in MSDN. See SELECT Statement
description:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_select_statement.asp

Also take a look at "SQL Server CE Books Online":
...Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows
CE\sqlce.chm



Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com