.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson
Eminent IT
Sandeep Singh

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Performing search on MS SQL Server 2008 database

Posted By: Venkat     Posted Date: September 11, 2009    Points:2   Category :Sql Server
We have built an ASP.NET application (with C#.net language) and hosted on Windows Server 2003 Operating System.

The database is MS SQL Server 2008.

Now we need to do a search involving 4 tables and one of the column of table is varchar (2400) and the other columns are of normal lengths (E.g. Varchar(50) etc.). This search gets fired whenever an user enters a keyword in the search box and presses enter key. The number of searchable records in future could be in lakhs.

Would you please let me know the best method of searching these tables?

If would be great if you could provide a reference document or web reference (If needed).

Many Thanks,
Venkat. .

Author: Amit Mehra             
Posted Date: September 12, 2009     Points: 5   


You should go for full Text Search search concept available in sql server please refer this article to get details of Full text search engine..



Please "Mark As Answer " if this post help you.

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend