22,209
社区成员
发帖
与我相关
我的任务
分享
消息 102,级别 15,状态 1,过程 proc_Getpage,第 8 行
'+@tbname+' 附近有语法错误。
消息 102,级别 15,状态 1,过程 proc_Getpage,第 8 行
'+@tbname+' 附近有语法错误。
if exists(select * from sysobjects where name='proc_Getpage')
drop procedure proc_Getpage
go
create proc proc_Getpage
@fieldname varchar(10),
@tbname varchar(10),
@pagesize int,
@strWhere varchar(100)
as
begin
select top 8 * from '+@tbname+' where '+@fieldname+' not in(select top ('+Convert(varchar,@pagesize)+'*8) '+@fieldname+' from '+@tbname+') and '+@strWhere+'
end
select top 8 * from v_meeting where mt_id not in(select top (1*8) mt_id from v_meeting) and mt_state='已召开'
if exists(select * from sysobjects where name='proc_Getpage')
drop procedure proc_Getpage
go
create proc proc_Getpage
@fieldname varchar(10),
@tbname varchar(10),
@pagesize int,
@strWhere varchar(100)
as
begin
declare @sql varchar(8000)
set @sql='select top 8 * from '+@tbname+' where '+@fieldname+' not in(select top ('+Convert(varchar,@pagesize)+'*8) '+@fieldname+' from '+@tbname+') and '+@strWhere+''
exec(@sql)
end