SQL存储过程出现错误，希望有SQL高手进行解答

来源：百度知道编辑：UC知道时间：2024/06/22 22:32:20

CREATE proc UP_Tm_LeaveChildren_GetModel
(
@Ccorp varchar(30),
@Classname varchar(20),
@Cname varchar(40),
@LeaveSDate varchar(30),
@LeaveEDate varchar(30),
@LeaveWhy varchar(20),
@PageIndex int,
@PageSize int
)

as

begin
declare @SqlText varchar(1024)

set SqlText='select top ' +cast(@PageSize as varchar(12))+'Ccorp,Classname,Childid,Cname,Csex,convert(char(10),Cbirth,120) as Cbirth,
convert(char(10),InDate,120) as InDate,Address,Hphone,convert(char(10),LeaveDate,120) as LeaveDate,LeaveWhy
from (select * from Tm_LeaveChildren
where Ccorp ='+''''+@Ccorp+''''+'and Classname like '+''''+'%'+@Classname+'%' +''''+ 'and Cname like'+'''' + '%'+@Cname+'%' +''''+ 'and Leav

set @sqltext吧，少了@
begin
declare @SqlText varchar(1024)

set @SqlText='select top ' +cast(@PageSize as varchar(12))+ ........

Tm_LeaveChildren 别名？表？还是查询结果集？

sql存储过程问题请教Sql 存储过程？关于SQL存储过程关于sql存储过程 sql数据库存储过程 Sql存储过程 sql 存储过程游标 sql存储过程解释 sql创建存储过程存储过程调用错误