这是codesmith产生的分页程序。它无法被执行;代码如下:CREATE PROCEDURE alarm_level_setup_GetPaged
(
@WhereClause varchar (2000) ,
@OrderBy varchar (2000) ,
@PageIndex int ,
@PageStart int ,
@PageSize int
)
BEGIN
SELECT
`alarm_level_id`,
`variable_type_id`,
`effect_range_minimum_value`,
`effect_range_maximum_value`,
`correspond_alarm_level`,
`name`
FROM
`alarm_level_setup`
${WhereClause}
${OrderBy}
LIMIT @PageSize OFFSET @PageStart;
SELECT count(*) as TotalRowCount
FROM `alarm_level_setup`
${WhereClause};
END;
请问:语法错误有哪些?如何最小的改动?
我是mysql新手,谢谢!
(
@WhereClause varchar (2000) ,
@OrderBy varchar (2000) ,
@PageIndex int ,
@PageStart int ,
@PageSize int
)
BEGIN
SELECT
`alarm_level_id`,
`variable_type_id`,
`effect_range_minimum_value`,
`effect_range_maximum_value`,
`correspond_alarm_level`,
`name`
FROM
`alarm_level_setup`
${WhereClause}
${OrderBy}
LIMIT @PageSize OFFSET @PageStart;
SELECT count(*) as TotalRowCount
FROM `alarm_level_setup`
${WhereClause};
END;
请问:语法错误有哪些?如何最小的改动?
我是mysql新手,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货