Limit + Mssql

[obrienkev]

Hi all,

What is the equivalent of mysql's LIMIT clause for MSSQL Server?

Thanks.

 $find_date = mssql_query("select date from date where date = '$value' 
                 and course_ID = '$course'    LIMIT 1"); 

[briansol]

SELECT Top X from table

keep in mind, MS doesn't support limit X,Y for starting ranges.

[r937]

kev, are you sure this is what you're running in MySQL --

select date 
  from date 
 where date = '$value' 
   and course_ID = '$course' 
LIMIT 1

because all this does is determine whether there exists at least one row in the "date" table for the given "date" value and course value -- assuming that there would be more than one (which, the longer i think about it, doesn't make sense)

you are returning the "date" value but of course you could really return anything, right? i mean, because you already know the "date" value

so you could do this in SQL Server --

select 'Yep!' 
 where exists
     ( select 937
         from date
        where date = '$value' 
          and course_ID = '$course' )

[obrienkev]

Hi Rudy,

I'm using LIMIT to display just one result. So is the above right in what I want to do?

[r937]

is it right for what you're trying to do?

that depends on what you're trying to do, which, and please don't take this the wrong way, you haven't communicated very well at all

is the same course available on the same day more than once?

[vgarcia]

SELECT TOP 1 * 
FROM table
ORDER BY field

The TOP syntax works in any version of SQL Server from 7 on up.