SQL2000存储过程的调用问题

[DarkNight]

存储过程:CREATE procedure NS_GetPaged
(@startIndex int,@endIndex int,@opt varchar(256))
as
set nocount on
exec('declare @indextable table(id int identity(1,1),nid int) set rowcount '+@endIndex+'
insert into @indextable(nid) select B.NcID from pH_Person_Base B inner join pH_Person_Info I on B.NcID=I.NcID where '+@opt+' order by B.regdate desc
select B.perid,B.LastUpdate_Time,B.username,B.regdate,B.flag,B.Nc_best_flag,I.realName,I.sex,I.Age,I.edus,I.personPhone,I.workwill1,I.topall,I.photourl,I.appraise,I.Works,I.AreaWill1,I.AreaWill2,I.AreaWill3,I.WorkWillClass1,I.WorkWillClass2,I.WorkWillClass3 from pH_Person_Base B inner join @indextable t on B.NcID=t.nid inner join pH_Person_Info I on B.NcID=I.NcID 
where (t.id between '+@startIndex+' and '+@endIndex+') order by B.LastUpdate_Time desc')
set nocount off
RETURN
GO



调用方法:sql="exec NS_GetPaged "&Thepage&","&nextnum&","""&SearchChar&"""" 


错误:开头的 标识符 太长。最大长度为 128。

程序要完成的功能是一个多条件选择的查询,查询条件通过用户自己选择,组合查询语句,调用存储过程,显示结果

[sy_binbin]

,@opt varchar(256))


这个先设大一些试试

[DarkNight]

我设过8000 还是报一样的错 !! 大家速度了 在线等```````````````

[sy_binbin]

sql="exec NS_GetPaged "&Thepage&","&nextnum&","&SearchChar&""

？？

[mjjzg]

将此SQL语句放到SQL区会更好

[DarkNight]

唉 总算解决了 但是又再一次见证了CSDN确实没什么能人

[boboware]

"号换成'