34,576
社区成员
发帖
与我相关
我的任务
分享
select title,gongneng,chengfen,maidian,shenhe,[date],id from cp
where
shenhe = '已审核'
and title like '%"+function.getStr(title)+"%'
or gongneng like '%"+function.getStr(title)+"%'
order by title
alter table cp add searchcolumn nvarchar(50)
go
CREATE NONCLUSTERED INDEX IX_cp ON dbo.cp(searchcolumn) ON [PRIMARY]
go
update cp set searchcolumn=function.getStr(title)
go
select title,gongneng,chengfen,maidian,shenhe,[date],id from cp
where
shenhe = '已审核'
and title like '%"+searchcolumn+"%'
or gongneng like '%"+searchcolumn+"%'
order by title
alter table cp add searchcolumn nvarchar(50)
go
CREATE NONCLUSTERED INDEX IX_cp ON dbo.tb0(searchcolumn) ON [PRIMARY]
go
update cp set searchcolumn=function.getStr(title)
go
select title,gongneng,chengfen,maidian,shenhe,[date],id from cp
where
shenhe = '已审核'
and title like '%"+searchcolumn+"%'
or gongneng like '%"+searchcolumn+"%'
order by title
function.getStr(title),
select title,gongneng,chengfen,maidian,shenhe,[date],id from cp
where
shenhe = '已审核'
and title like '%"+function.getStr(title)+"%'
or gongneng like '%"+function.getStr(title)+"%'
order by title
---------------------------------------
function.getStr(title),不知道这是个函数还是什么。
但有一点可以肯定的是,在SQL语句中两次用到这个函数,这样效率就会降低,起码楼主可以先将function.getStr(title)的返回值赋给一个变量。然后将SQL语句改成:
select title,gongneng,chengfen,maidian,shenhe,[date],id from cp
where
shenhe = '已审核'
and title like '%"+变量+"%'
or gongneng like '%"+变量+"%'
order by title