ottomatic Posted October 13, 2005 Share Posted October 13, 2005 I know that you can do a LIMIT in mysql statements but you can't do that in MS SQL. Does anyone know an alternative to the LIMIT command in MS SQL? Quote Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/ Share on other sites More sharing options...
Barand Posted October 23, 2005 Share Posted October 23, 2005 SELECT TOP 10 * FROM tablename Quote Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/#findComment-9059 Share on other sites More sharing options...
Munchen Posted November 21, 2005 Share Posted November 21, 2005 Take a look at [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=76155\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=76155[/a] how I did it. Quote Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/#findComment-9758 Share on other sites More sharing options...
raul Posted February 24, 2006 Share Posted February 24, 2006 [!--quoteo(post=306053:date=Oct 13 2005, 05:20 PM:name=ottomatic)--][div class=\'quotetop\']QUOTE(ottomatic @ Oct 13 2005, 05:20 PM) 306053[/snapback][/div][div class=\'quotemain\'][!--quotec--] I know that you can do a LIMIT in mysql statements but you can't do that in MS SQL. Does anyone know an alternative to the LIMIT command in MS SQL? U could take a look at [a href=\"http://ionescuraul.users.phpclasses.org/browse/package/2832.html\" target=\"_blank\"]http://ionescuraul.users.phpclasses.org/br...ckage/2832.html[/a] Quote Link to comment https://forums.phpfreaks.com/topic/2656-ms-sql-query/#findComment-12334 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.