高考问答品冠礼品商城官网兑换:sql 存储过程的问题
来源：百度文库 编辑：高考问答 时间：2024/04/27 17:29:22
请大家帮忙看看这个存储过程的问题在哪儿？谢谢！！
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类型的
而且似乎不用加括号把