SQL stored procedure with fuzzy query criteria

A simple stored procedure:

Create procedure [dbo]. [Proc_seachjob] (@startRecordIndexint, @endRecordIndexint, @seach nvarchar (Ten), @docount bit) asSetNocount onif(@docount =1)--just need to put the%with the search string by stitching the way you canSelectCOUNT (*) fromJobwhereName like'% @seach%'or work_address like'% @seach%'Elsebegindeclare @indextable table (IDintIdentity1,1), nidint)Setrowcount @endRecordIndexinsert into @indextable (NID)SelectId fromJobwhereName like'% @seach%'or work_address like'% @seach%'ORDER BY createtime DescSelect* fromJob O, @indextable twhereO.id=T.nidand t.id between @startRecordIndex and @endRecordIndex order by T.idendSetNocount OFF

SQL stored procedure with fuzzy query criteria