October 2nd, 2003, 02:06 PM
|
 |
Banned ;)
|
|
Join Date: Nov 2001
Location: Glendale, Los Angeles County, California, USA
|
|
|
>> PS. most of the difficult stuff takes place in arrays in PHP, the queries are all rather simple.
Depends on what you mean by "simple". For instance, to select the first 50 rows in mySQL, you'd use:
SELECT field1, field2 FROM table LIMIT 50
In MS SQL, the equivalent is:
SELECT TOP 50 field1, field2 FROM table
Then, there's no quick MSSQL equivalent for this:
SELECT field1, field2 FROM table LIMIT 50, 10
As you can see, there are some differences in even the "simple" select statements.
__________________
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
Puzzle of the Month solved by Keath and KevinADC, superior perl programmers of the month
Looking for a perl job with kick-*** programmers in a well-known NASDAQ listed tech company with branches in the US and Europe? We're hiring. PM me for details. Requirements
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
