here i wrote a split function to split the values in the parameter

@DATAS varchar(8000)='siva coffe shop orian super market '

select*from dbo.Split(@DATAS,'')ds

which will split hte datas like this

...

it read this

http://www.sqlservercentral.com/articles/Indexing/68439/

here i didn't understand

if there is an simple example means i can i understand easily

select * from sys.indexes

select * from sys.index_columns ...

hi

Sean Lange

and

Lynn Pettis

i know iam not worth for anything thats why spliting the proc also

i dont even no what is index but i...

here i am writing a search proc some people suggest me to use indexing if u use indexing mean u can reduce time when...

hi Lynn Pettis

i used the function to split the words which was given in the parameter

@values=' the city words'

the

city

words

and it has to...

here i used CROSS APPLY dbo.DelimitedSplit8k(@VALUES,'')ds funtion to split the words 'the cri word'

declare @value varchar(800)='the cri word'

function name...

but here is used the cross split function in my original proc which i mentioned

i want to check all column it was itwas not...

for this proconly i have given sample example iam trying this for this proc only

ALTER PROCEDURE [dbo].[SP_Search]

(

@CategoryId int=NULL,

...

thanks

Sean Lange

thanks

dwain.c

it was working fine

can u plz give one idea is there any chance to avoid null value instead of that replace...

hi J Livingston

i didn't use rand() function instead of that i used NEWID() function to select randomly this is solution for imageid and imagedescription...

i just found the solution for this my friends no thanks

here i just opened job and i made a right click the i found new job i just selected that than after that ...

hi havindg this problem when i execute this query

-- sample data

declare @test1 table(

id int,

telephone varchar(4000)

)

insert into @test1

select 1,'004-26487,004-84576,9845678682' union all

select...

plz give some idea about jobs in sqlserver