Re: SQL 2005 Full Text Multi-Column Ranking

craig_at_rampgroup_dot_com wrote on 13 Dec 2005 18:18:39 -0800:

> I looked all over the internet and can't find a straight answer, so
> hopefully someone here will know the answer for a fact.

In SQL Server 2005 you can provide a column list instead of a single column
if you want to get a rank that's valid across multiple columns. eg.

select * from containstable (program, (Name, Description), 'ISABOUT
("soccer")')


Dan


.

Relevant Pages

  • problem in connecting sql server
    ... i am new to sql server and .net programing here is a problem i got ... while trying to connect sql server over internet ... Prev by Date: ...
    (comp.programming)
  • Re: Best Pratice-Remore ADO Access
    ... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
    (microsoft.public.vb.database.ado)
  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: SQL CE Setup 101... C#
    ... the Internet Url. ... We have seen issues when we give IP address in internet ... Try using the sql server instance name. ... > // Create the Local SSCE Database subscription. ...
    (microsoft.public.sqlserver.ce)
  • Re: MDB vs ADP
    ... So whilst in many cases it can be very slow using an adp / mdb to connect to ... a sql server over the net you can make it work. ... > MDB and ADP over the Internet; not only when loading 1000 records but also ...
    (microsoft.public.access.adp.sqlserver)