lyshshe ispol"zovat" containstable :

CREATE PROCEDURE sps_containstable_test

@from_table nvarchar(517),
@freetext_column sysname,
@string_search nvarchar(1000)

as

declare @SQL varchar(8000),
@unique_key_col_name sysname,
@Select_List varchar(80),
@table_id integer

select @Select_List = '*'
SET @table_id = Object_Id(@from_table)
SET @unique_key_col_name = Col_Name( @table_id, ObjectProperty(@table_id, 'TableFullTextKeyColumn') )


SELECT @SQL = 'SELECT' + ' ' + @select_list
select @SQL = @SQL + ' ' + 'FROM' + ' ' + @from_table
select @SQL = @SQL + ' AS FT_TBL, containstable(' + @from_table + ', ' + @freetext_column + ',''' + @string_search + ''') AS KEY_TBL '
select @SQL = @SQL + ' WHERE ' + ' '
SELECT @SQL = @SQL + ' FT_TBL.'
SELECT @SQL = @SQL + @unique_key_col_name + ' = KEY_TBL.[KEY] '

print @SQL

EXEC(@SQL)
GO

vizov :

exec sps_containstable_test

@from_table ='table_name
@freetext_column ='col_name_where_looking'
@string_search ='search_word'