SQl Server FREETEXTTABLE return matched text.
Posted on 2011-04-19
I have a table say tblResumes
ID Name Position Resume(nText)
I run a FREETEXTTABLE search.
I want to be able to retun only the Text from the column(Resume) which match the keywords in the FREETEXTTABLE search.
Something along the lines of google results.
For Example(This is a sample resume in the "Resume" Column) :
System Admin and database Administrator job involves the following: IMV Project System Implement Schedule Control and Follow up (20 of Sub Systems). - Cooperate with outsourcing and Global Toyota company to implement system as following items:User Requirement, Infra Structure Design, Database Design, User Design, Unit Test, System Test, User Acceptance Test, System Go-live etc. Application Investigate Skill of Maintenance Phase. System Administrator: Server Specification Design. Operating System Performance Utilization Monitoring and Analysis to scale out. Application Deployment logging version and check shet control. System Backup and restore. Disaster Recovery Plan Design and Backup Site of Server Room implementation. IIS Web Service configuration and Performance Tuning. Application Component Service configuraiton. Scheduled Task Configuration. N-Tier Application Knowledge and Implementation. SAN Storage administrator (Raid 1+0). LAN/WAN/VPN, Intenet, Intranet Configuration, Proxy/Firewall/Ftp configuration. Implement and Maintaining MS Windows Server Active Directory Infra-Structure. Database Administrator: Setting Task of Daily, Monthly, Yearly of Database Maintenance Plan such as Automatic Full Backup, Rebuild index, Data Integrity Check: - Microsoft SQL Server 7 Database Servers (ERP-Powercerv System). - Microsoft SQL Server 2000 Database Servers (SCMS Phase 1 have 11 Sub System). - Microsoft SQL Server 2000 Database Servers (SCMS Phase 2 have 5 Sub System). - Microsoft SQL Server 2000 Database Servers (SIS). - Microsoft SQL Server 2000 Database Servers (Tool). Microsoft SQL Server Cluster Configuration and Tuning. Database Installation, Standard Configuration and Controlling User Access Configuration. Configuration of Database Performance Tuning. Database Problem Investigate and Solving. Database Performance Utilization Monitoring and Analysis to scale out. Replication Implementation between various database. Other
IF I run a search for 'Microsoft Database Administrator'
Is it possible to return only matched text chunks rather than return all the text from that column. Something like return the 5 preceeding and 5 succeeding words of the macthed keywords.
Is it possibel to do in SQl server or should this be done from the application end?
If yes then please guide me in the right direction.