Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 21:51:03
|
Saul writes "I have an Index built under Index server and I query it using SQL server 2K (Query Analyzer), in this way:
select * from openquery(LinkedServer,'
SET PROPERTYNAME ''d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1'' PROPID ''MyProperty''
as MyProperty ;
SET PROPERTYNAME ''d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1'' PROPID ''date'' as date
TYPE VT_FILETIME;
select MyPropery, date from scope()
WHERE CONTAINS(titulo,''juan'')
ORDER BY date ')AS Q
It is Ok, but I also need to restrict the number of rows returned using a "Select
Top N" statement. It doesn't work this way in the Openquery function, if you know
how to do it, your help would be great.
Regards.
Saul." |
|
|
|
|
|
How to use a Select Top N