query plan and fragmentation good.

regards
pols

before running sp we insert 50000 records and table already have index on uid.

Regards
Pols

create table data(id int,name nvarchar(max))

declare @id int,@name nvarchar(max)

set @id =1
set @name='abcd'(some images)

insert into data(id,name)
values(@id,@name)

here insert is not a problem.after insert...

insert into data(id,name)
values(@id,@name)

SELECT *
FROM SomeTable
WHERE Somecolumn NOT LIKE '%[a-zA-Z0-9]%'

it is not working

but some records 

??????? ???? ??????
?????????
????? ??? ???? ?????? ??????????
??????????
???????????????????

from .net we call the storeproedure then automatically exec the sp and donload the excel file.so we need the excel donload the file store procedure.

same row

Table

Idintno410 0 no(n/a)(n/a)NULL

Titlenvarcharno1000 no(n/a)(n/a)Latin1_General_CI_AS

CompanyNamenvarcharno1000 no(n/a)(n/a)Latin1_General_CI_AS

Salaryintno410 ...