消息 319,级别 15,状态 1,过程 page_fy,第 19 行
关键字 'with' 附近有语法错误。如果此语句是公用表表达式或 xmlnamespaces 子句,那么前一个语句必须以分号结尾。
消息 156,级别 15,状态 1,过程 page_fy,第 24 行
关键字 'else' 附近有语法错误。语句if(@k_word='')
WITH a AS (
SELECT ROW_NUMBER() OVER (ORDER BY id DESC)AS Row,id,title,tj_time,small_pic from news where lb_code=@lb_code)
elseWITH a AS (
SELECT ROW_NUMBER() OVER (ORDER BY id DESC)AS Row,id,title,tj_time,small_pic from news where lb_code=@lb_code)
SELECT id,title,tj_time,small_pic FROM a WHERE Row between @pagestart and @pageend
关键字 'with' 附近有语法错误。如果此语句是公用表表达式或 xmlnamespaces 子句,那么前一个语句必须以分号结尾。
消息 156,级别 15,状态 1,过程 page_fy,第 24 行
关键字 'else' 附近有语法错误。语句if(@k_word='')
WITH a AS (
SELECT ROW_NUMBER() OVER (ORDER BY id DESC)AS Row,id,title,tj_time,small_pic from news where lb_code=@lb_code)
elseWITH a AS (
SELECT ROW_NUMBER() OVER (ORDER BY id DESC)AS Row,id,title,tj_time,small_pic from news where lb_code=@lb_code)
SELECT id,title,tj_time,small_pic FROM a WHERE Row between @pagestart and @pageend
else ;WITH a AS ( SELECT ROW_NUMBER() OVER (ORDER BY id DESC)AS Row,id,title,tj_time,small_pic from news where lb_code=@lb_code )
SELECT id,title,tj_time,small_pic FROM a WHERE Row between @pagestart and @pageend
';' 附近有语法错误。
消息 156,级别 15,状态 1,过程 page_fy,第 24 行
关键字 'else' 附近有语法错误。