测试了一下,速度差不多... -------------------------------------------------------------------- --总数据:15574条declare @dt1 datetime,@dt2 datetime,@dt3 datetime,@dt4 datetime set @dt1=getdate() select * from bas_account where name like '%中%' set @dt2=getdate()set @dt3=getdate() select * from bas_account where charindex('中',name)>0 set @dt4=getdate()select DT1=datediff(ms,@dt1,@dt2),DT2=datediff(ms,@dt3,@dt4)
速度差不多但是 like 'abc%' 要比 charindex('abc', field1) = 1快得多, 还是推荐用like
--------------------------------------------------------------------
--总数据:15574条declare @dt1 datetime,@dt2 datetime,@dt3 datetime,@dt4 datetime
set @dt1=getdate()
select * from bas_account where name like '%中%'
set @dt2=getdate()set @dt3=getdate()
select * from bas_account where charindex('中',name)>0
set @dt4=getdate()select DT1=datediff(ms,@dt1,@dt2),DT2=datediff(ms,@dt3,@dt4)
还是推荐用like