中科新闻网win10共享分区:sql 存储过程的问题
来源：百度文库 编辑：中科新闻网 时间：2024/04/20 17:50:12
请大家帮忙看看这个存储过程的问题在哪儿？谢谢！！
CREATE proc dbo.pageproc
@pages int
as
set nocount on
declare @sqlstr varchar(100)
set @sqlstr="select top 10 * from t1 where id>(select max(id) from (select top " + str(@pages) +" id from t1 order by id) as t) order by id"
exec (@sqlstr)
set nocount off
CREATE proc dbo.pageproc
@pages int
as
set nocount on
declare @sqlstr varchar(100)
set @sqlstr="select top 10 * from t1 where id>(select max(id) from (select top " + str(@pages) +" id from t1 order by id) as t) order by id"
exec (@sqlstr)
set nocount off
exec 只能执行nvarchar类型的
而且似乎不用加括号把