|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Doing a CONTAINS search on multiple tables and columns combined. Posted by GM at 5/28/2004 9:27:34 PM I want to do a CONTAINS search on several columns combined.
This example searches each column separately, so that a record is not
included that has one of the search terms in the Desired Position and the
other two search terms in a section body.
SET @SearchPhrase = 'Engineer AND SQL AND VB'...more >>
Hillary's Searchpage.htm Posted by Richard French at 5/28/2004 4:01:20 PM I've started to use the code within searchpage and am having trouble with
Noisewords at the beginning and end of the search phrase.
For example:
When I specify "Bill and any Manager" the result is "Bill Manager".
When I specify "any Manager and Bill" the result is "any Manager Bill".
I ...more >>
FTS Security Issue Posted by Norman at 5/28/2004 10:46:07 AM Hi
FTS will not populate the catalogs. 0 Items
I have a new installation W2003 with SQL2K Sp3
The SQL Server is running with a high security configuration
All the SQL services are running under an account Domain\SQLService which is a plain old user in the domain and on the SQL Server box
Th...more >>
display properties Posted by mike at 5/25/2004 3:42:29 PM hi, i cant seen to change my color settings or the size of
my desktop. i dont know what my driver is and i have tried
installing others out of the list given on the win98 disk
and it isnt working, can somebody please help me out
because i cant view anyting in a higher resolution and i
cant...more >>
Accent-sensitive Posted by Marcos Stabel at 5/25/2004 8:29:17 AM My SQL is instaled with CAse-Insensitive and Accent-Insensitive, but when I
search some thing with Full Text Search the result is diferent using accent
or not.
My server is a Windows 2000 server and MS SQL Server 2000.
Tia
Marcos Stabel
...more >>
where'd my change tracking go? Posted by ch at 5/25/2004 7:57:45 AM sql2000 build 818
i have 3 tables that have change tracking on and update index in
background on.
i created a text filegroup and assigned those 3 tables to that text
filegroup.
after that was done, the change tracking is now off and so i had to go
back and re-enable change tracking.
shouldn't...more >>
FTS menu optons not active in XP Pro SQL Developer Edition Posted by GM at 5/24/2004 1:01:18 PM Microsoft Search service does not appear in my list of Services, and
full-text menu items are grayed out in Enterprise Manager.
Is FTS not available on Windows XP Professional computers? I have the
developer edition of SQL Server from a Microsoft Universal subscription.
Generally I develop o...more >>
searching with xml tags no longer works in 2003 Posted by zach_john6488 NO[at]SPAM go.com at 5/24/2004 12:01:06 PM Notice that I said with not within.
On a Win 2K machine this query works, on a 2003 same sql build the
query returns way too many rows. My guess is that I'm getting every
row where HEADLINE_EXROUTING contains the letter 'V' somwhere in the
entire text, instead of where it contains the text
"...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
multiple columns search with 'AND' Posted by Andrew Jocelyn at 5/23/2004 12:00:41 PM Hi
Can someone tell me why I can search multiple columns in 1 table using a
single CONTAINS with 'OR' operator but it dosn't work for 'AND' queries? I
want to be able to do 'AND' searches accross 50 odd columns in a table.
Here's an example to show you what I mean (A Full-Text index is working...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |