关于一段错误的SQL语句(帮顶有分)
各位高手帮忙看看这段程序,急,谢谢~~~~
===========================================================================
Create Proc MoreConditionSlect @Habitation varchar(100),@Sex char(1),@Eduction varchar(10),
@WorkTime varchar(20),@NowJobtype varchar(50),
@NowJobName varchar(50),@ISManage char(1),
@Area varchar(30),@Trade varchar (50),@RefurbishTime DateTime,
@Language varchar(20),@LS varchar(10),@StartTime DateTime,@EndTime DateTime,@Company varchar(50)
AS
select UB_UserName,UB_Tname,UB_Brithday,UB_Habitation,UB_SEX,UB_Eduction,UB_WorkTime,UJ_NowJobtype,UEI_Company,UJ_Nowtrade,UJ_NowJobName,UJ_ISManage,UJ_Area,UJ_Trade,UR_RefurbishTime,ULI_Language,ULI_LS from (select a.*,b.*,c.*,d.*,e.* from dbo.U_Base_Info as a, dbo.U_Job_Intent as b,dbo.U_Resume_Manage as c,dbo.U_Lang_Info as d,dbo.U_Experience_Info as e where a.UB_UserName = b.UJ_UserName and b.UJ_UserName = c.UR_BelongUser and c.UR_BelongUser = d.ULI_UserName and d.ULI_UserName = e.UEI_UserName and e.UEI_Btime in (select max(UEI_Btime) from dbo.U_Experience_Info group by dbo.U_Experience_Info.UEI_UserName ) ) as Exp1
where ( UB_Habitation like '% '+@Habitation+ '% ' or @Habitation = ' ' ) and
( UB_SEX like '% '+@Sex+ '% ' or @Sex = ' ' ) and
( UB_Eduction like '% '+@Eduction+ '% ' or @Eduction = ' ' ) and
( UB_WorkTime like '% '+@WorkTime+ '% ' or @WorkTime = ' ' ) and
( UJ_NowJobtype like '% '+@NowJobtype+ '% ' or @NowJobtype = ' ' ) and
( UJ_NowJobName like '% '+@NowJobName+ '% ' or @NowJobName = ' ' ) and
( UJ_ISManage like '% '+@ISManage+ '% ' or @ISManage = ' ' ) and
( (set @Language = replace(@Language, ', ', '% ')
set @Language = '% ' + @Language + '% ')
patindex (@Language,ULI_Language)) or ULI_Language = ' '
) and
( UJ_Area like '% '+@Area+ '% ' or @Area = ' ' ) and
( UJ_Trade like '% '+@Trade+ '% ' or @Trade = ' ' ) and
( UR_RefurbishTime <= @RefurbishTime or @RefurbishTime = null ) and
( ULI_LS like '% '+@LS+ '% ' or @LS = ' ' ) and
( (UB_Brithday > = @StartTime and UB_Brithday <= @EndTime) or (@StartTime = null and @EndTime = null) ) and
( UEI_Company like '% '+@Company+ '% ' or @Company = ' ' )
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
服务器: 消息 156，级别 15，状态 1，过程 MoreConditionSlect，行 16
在关键字 'set ' 附近有语法错误。
服务器: 消息 170，级别 15，状态 1，过程 MoreConditionSlect，行 17
第 17 行: ') ' 附近有语法错误。
==========================================================================
麻烦了~
[解决办法]
看看先,先帮你顶下
[解决办法]
帮顶
[解决办法]
up
[解决办法]
就是set那出错了
删除
[解决办法]
顶下
接分
[解决办法]
加分
[解决办法]
--我在你另一贴补给出答案了吗
ALTER Proc MoreConditionSlect
@Habitation varchar(100),@Sex char(1),@Eduction varchar(10),
@WorkTime varchar(20),@NowJobtype varchar(50),
@NowJobName varchar(50),@ISManage char(1),
@Area varchar(30),@Trade varchar (50),@RefurbishTime DateTime,
@Language varchar(20),@LS varchar(10),@StartTime DateTime,@EndTime DateTime,@Company varchar(50)
AS
set @Language = replace(@Language, ', ', '% ')
set @Language = '% ' + @Language + '% '
select UB_UserName,UB_Tname,UB_Brithday,UB_Habitation,UB_SEX,UB_Eduction,UB_WorkTime,UJ_NowJobtype,UEI_Company,UJ_Nowtrade,UJ_NowJobName,UJ_ISManage,UJ_Area,UJ_Trade,UR_RefurbishTime,ULI_Language,ULI_LS from (select a.*,b.*,c.*,d.*,e.* from dbo.U_Base_Info as a, dbo.U_Job_Intent as b,dbo.U_Resume_Manage as c,dbo.U_Lang_Info as d,dbo.U_Experience_Info as e where a.UB_UserName = b.UJ_UserName and b.UJ_UserName = c.UR_BelongUser and c.UR_BelongUser = d.ULI_UserName and d.ULI_UserName = e.UEI_UserName and e.UEI_Btime in (select max(UEI_Btime) from dbo.U_Experience_Info group by dbo.U_Experience_Info.UEI_UserName ) ) as Exp1
where ( UB_Habitation like '% '+@Habitation+ '% ' or @Habitation = ' ' ) and
( UB_SEX like '% '+@Sex+ '% ' or @Sex = ' ' ) and
( UB_Eduction like '% '+@Eduction+ '% ' or @Eduction = ' ' ) and
( UB_WorkTime like '% '+@WorkTime+ '% ' or @WorkTime = ' ' ) and
( UJ_NowJobtype like '% '+@NowJobtype+ '% ' or @NowJobtype = ' ' ) and
( UJ_NowJobName like '% '+@NowJobName+ '% ' or @NowJobName = ' ' ) and
( UJ_ISManage like '% '+@ISManage+ '% ' or @ISManage = ' ' ) and
( patindex(@Language,ULI_Language)> 0 or ULI_Language = ' ') and
( UJ_Area like '% '+@Area+ '% ' or @Area = ' ' ) and
( UJ_Trade like '% '+@Trade+ '% ' or @Trade = ' ' ) and
( UR_RefurbishTime <= @RefurbishTime or @RefurbishTime = null ) and
( ULI_LS like '% '+@LS+ '% ' or @LS = ' ' ) and
( UJ_Trade like '% '+@Trade+ '% ' or @Trade = ' ' ) and
( (UB_Brithday > = @StartTime and UB_Brithday <= @EndTime) or (@StartTime = null and @EndTime = null) ) and
( UEI_Company like '% '+@Company+ '% ' or @Company = ' ' )
GO
[解决办法]
不太懂 不过顶了
[解决办法]
顶一下
[解决办法]
知道帮顶有分后，我也过来蹭分了
