I have to implement full text search on sql server tables. It is already implemeted on a column(EmpName) in one of the table Employee. I need to swich to a different column(Resume) and also needs to implement on two new tables.
Could any one help me out on this. Here is the existing stored proc.
ALTER PROCEDURE [dbo].[SearchFullTextContent]
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
select empID from Employee
where freetext(Employee.EmpName, @paramQuery)