|
Home > Archive > MS SQLCE > July 2005 > TOP Clause
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Steve B. 2005-07-18, 9:23 am |
| Hi,
Is there any way other than coding to get the same result than the TOP
clause available only on desktop SQL Server version ?
If I query the DB using "SELECT TOP 3 * FROM anytable", I get a parsing
error on TOP.
Thanks,
Steve
| |
| Darren Shaffer 2005-07-18, 9:23 am |
| no, the only aggregate functions supported in SQL CE are
AVG, COUNT, MAX, MIN, and SUM.
SQL Mobile (next version of SQL CE) is supposed to
include support for TOP but it's not there in the betas yet.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Steve B." <steve_beauge@com.msn.swap_com_and_msn> wrote in message
news:OC%23t515iFHA.1044@tk2msftngp13.phx.gbl...
> Hi,
>
> Is there any way other than coding to get the same result than the TOP
> clause available only on desktop SQL Server version ?
>
> If I query the DB using "SELECT TOP 3 * FROM anytable", I get a parsing
> error on TOP.
>
> Thanks,
> Steve
>
| |
| Steve B. 2005-07-18, 9:23 am |
| Ok. It should be a loss of performance on heavy tables, since the whole
table need to be placed in memory (disconnected datasets using C#).
Thanks
"Darren Shaffer" < darrenshaffer@discus
sions.microsoft.com> a écrit dans le
message de news: O0N0gS6iFHA.3288@TK2MSFTNGP09.phx.gbl...
> no, the only aggregate functions supported in SQL CE are
> AVG, COUNT, MAX, MIN, and SUM.
>
> SQL Mobile (next version of SQL CE) is supposed to
> include support for TOP but it's not there in the betas yet.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Steve B." <steve_beauge@com.msn.swap_com_and_msn> wrote in message
> news:OC%23t515iFHA.1044@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|