22,210
社区成员
发帖
与我相关
我的任务
分享
select * from info_fair_scene_job with(nolock) where scene_id='49' and (CONTAINS(station, '销售')) order by newid()
[code=SQL]
select * from info_fair_scene_job with(nolock) where scene_id='49' and (CONTAINS(station, '销售'))
|--Merge Join(Inner Join, MERGE:([Full-text Search Engine].[KEY])=([cqjob-net].[dbo].[info_fair_scene_job].[job_id]), RESIDUAL:([cqjob-net].[dbo].[info_fair_scene_job].[job_id] = [Full-text Search Engine].[KEY]))
|--Sort(ORDER BY:([Full-text Search Engine].[KEY] ASC))
| |--Remote Scan(OBJECT:(CONTAINS))
|--Clustered Index Scan(OBJECT:([cqjob-net].[dbo].[info_fair_scene_job].[PK_INFO_FAIR_JOB]), WHERE:([cqjob-net].[dbo].[info_fair_scene_job].[scene_id]=(49)) ORDERED FORWARD)
select * from info_fair_scene_job where scene_id='49' and station like '%销售%'
select * from info_fair_scene_job with(nolock) where scene_id='49' and (CONTAINS(station, '销售'))
select * from info_fair_scene_job where scene_id='49' and station like '%销售%'
select * from info_fair_scene_job with(nolock) where scene_id='49' and (CONTAINS(station, '销售'))