fm_fts_optAuthor_contains.sql
If Exists (Select * From sysobjects Where name = N'fm_fts_optAuthor_contains' And user_name(uid) = N'dbo')
Drop Procedure dbo.fm_fts_optAuthor_contains
Go
CREATE PROCEDURE fm_fts_optAuthor_contains
(
@search varchar(255),
@tblname char(64),
@where varchar(255)
)
As
set nocount on
exec fm_fts_create_table @tblname
exec("insert into " + @tblname +
"Select distinct stuff('../images/icon.gif',15,0,coll) as Icon," +
"stuff('javascript:Dolong()',19,0,ltrim(str(t.bib#))) as Link," +
"t.title,t.coll,t.call,convert(char(4),t.pubdate,112) as Pubdate " +
"from Title as t, Author as a, TitleAuth as ta " +
"where (t.bib# = ta.bib# and ta.auth# = a.auth#) and " +
"t.n_items>0 AND CONTAINS(a.*, '" + @search + "')" + @where)
Go