CodeVerge.Net Beta
Login Idy
Register Password
  Forgot?
Explore    Item Entry    Members   
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML





Zone: > NEWSGROUP > Asp.Net Forum > migration_to_asp.net.migrating_from_php_to_asp.net.php_to_asp.net_migration_assistant_alpha Tags:
Item Type: NewsGroup Date Entered: 11/21/2007 6:13:32 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 4 Views: 12 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
5 Items, 1 Pages 1 |< << Go >> >|
webhay
Asp.Net User
Limite in Select in mysql11/21/2007 6:13:32 PM

0/0

Hi all,

   I am trying to find how can i translate limit in select statment in mysql to ms sql statment is there is any thing like it in ms sql?

 

sms
nikki_doer_of_t
Asp.Net User
Re: Limite in Select in mysql11/21/2007 6:33:32 PM

0/0

TOP

select whatever from table limit 10

is

select top 10 whatever from table 
webhay
Asp.Net User
Re: Limite in Select in mysql11/21/2007 6:45:02 PM

0/0

but mysql " Select what ever from table limit 10,20 " i can do range 10 to 20 or 20 to 40.

how can i do that in Sql can i do top 10,20 ?

Thank you so much

Sms
nikki_doer_of_t
Asp.Net User
Re: Limite in Select in mysql11/21/2007 7:24:27 PM

0/0

No, not exactly. TOP sucks compared to LIMIT. You want it for paging, like I did?

If you have sql server 2005, you can do this sort of hack like I had to.

select * from (
    SELECT TOP 100 PERCENT ROW_NUMBER() OVER (ORDER BY myTimestampField DESC) AS ROWNUMBER,
    field1, field2, blah
   from myTable ) AS TBL
where ROWNUMBER between 10 and 20
 
webhay
Asp.Net User
Re: Limite in Select in mysql11/22/2007 1:36:26 AM

0/0

thank you so much

sms
5 Items, 1 Pages 1 |< << Go >> >|



Search This Site:


Meet Our Sponsors:



Other Resources:

ng.asp-net-forum.migrating_from_php_to_asp-net-php_to_asp ... Limite in Select in mysql. 4. 2. 11/22/2007 1:36:26 AM. calling an aspx page from a php site. ... as kporter - converter doesn't show up in VS. 1. 4. 2/23/2007 ...
Limite massimo Downloads rejetto, se ti va, fammi sapere, grazie in anticipo. French. Logged. rejetto. Administrator ... il limite potrebbe essere nel client anzichè sul server. ...
Límite en mensajes personales Join us in IRC chat. Select language: Home. Help. Search. Calendar. Login. Register ... Intento activar el límite a mensajes personales y no va. ¿ Cómo podría ...
Avatars com limite Select language: Home. Help. Search. Calendar. Login. Register ... Page created in 0.033 seconds with 18 queries. Page served by: 207.210.95.101. Loading...
Limite di download rejetto forum > Software > HFS ~ HTTP File Server > Italiano > Limite di download ... è possibile che ci sia un limite di download che non ho impostato io? ...
PHP to ASP.NET Migration Assistant Alpha Limite in Select in mysql. calling an aspx page from a php site. ... Having same problem as kporter - converter doesn't show up in VS ...
 
All Times Are GMT