Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Friday, March 23, 2012

Need Dynamic SQL Select turotrial

Need a tutorial on how to use ASP.net to dynamically build a SQL2000 compatible SELECT statement for a multiple keyword search. I need a search that will find any combination of one or more keywords in the Keyword string in any order.

Thank you

Do you mean full text searching? (Searching for a particular word within a lot of text)

|||

I have a database column 'Description' varchar(600) that contains product descriptions. I need to search it looking for any of the keywords contained in a Keyword string.

Example Keyword string - sail boat hardware

I need it to find all rows WHERE 'sail' or 'boat' or 'hardware' is found.

Thank you

|||

That form of search is more a full text search rather than a dynamic search. The latter is searching on one to many columns as selected at runtime.

|||

I am using a shared SQL2000 server. What I want to do is find a way in ASP.Net to take the keyword string entered and convert it into a Sql2000 select statement like below.

Keywords entered: sail boat hardware

SELECT Company, Phone, Description
FROM tblCompanyInfo
WHERE (tbl.CompanyInfo.Description LIKE '%' + "sail" + '%') OR (tbl.CompanyInfo.Description LIKE '%' + "boat" + '%') OR (tbl.CompanyInfo.Description LIKE '%' + "hardware" + '%')

|||

Look athttp://msdn2.microsoft.com/en-gb/sql/aa336289.aspx

|||

I am actualy looking for an ASP routine that splits the Keyword string and creates the OR elements for a Sql2000 compatible Sql SELECT command. I have looked at the many CONTAINS options discussed in the article but did not find any that offer a split like solution. As for a full text search, that option is not available at least not in the shared SQL environment that I am using.

Thank you

|||

In which case you need to roll your own text search solutions.

Create a Noise words table to contain words that you do not want indexed.

|||

Looks like someone should create a new ASP.Net SearchControl. A bunch of us out here could sure use it.

Thank you for the follow up.

sql

Monday, March 19, 2012

Need assisance with SQL2000 error.

I get the following errors in my VDI.log file in SQL2000:
2005/11/11 00:20:26 pid(172) tid(2008)
Error on Global\ACME_00__c978f75c_3672_4542_9fef_
8d224094ad27_
Error at CVDS::Close: Abnormal termination state
2005/11/11 00:20:26 pid(172) tid(2008)
Error on Global\ACME_00__c978f75c_3672_4542_9fef_
8d224094ad27_
Error at TriggerAbort: invoked
My Backup Exec software can't do a backup of this database.
Assistance will be much appreciated.Can you do a native backup? If so then I would give the makers of Backup
Exec a call.
Andrew J. Kelly SQL MVP
"TonyV" <TonyV@.discussions.microsoft.com> wrote in message
news:5AE41677-D082-4B67-838E-2DF9BDDAB40F@.microsoft.com...
>I get the following errors in my VDI.log file in SQL2000:
> 2005/11/11 00:20:26 pid(172) tid(2008)
> Error on Global\ACME_00__c978f75c_3672_4542_9fef_
8d224094ad27_
> Error at CVDS::Close: Abnormal termination state
> 2005/11/11 00:20:26 pid(172) tid(2008)
> Error on Global\ACME_00__c978f75c_3672_4542_9fef_
8d224094ad27_
> Error at TriggerAbort: invoked
> My Backup Exec software can't do a backup of this database.
> Assistance will be much appreciated.