拍查出 member_id<(select min(id)这段有问题 应该是
convert(varchar,(min(id)))
但却不知道如何加入到动态SQL句子里面
-->仅按楼主说的修改.convert加入到这里.
member_id<(select convert(varchar,min(id)) from( select top 5 * from photo where member_id in (select UserName from member1 where
id in
(select lessonid from lessonmessage where
public_er='sz')))A)
convert(varchar,(min(id)))
但却不知道如何加入到动态SQL句子里面
-->仅按楼主说的修改.convert加入到这里.
member_id<(select convert(varchar,min(id)) from( select top 5 * from photo where member_id in (select UserName from member1 where
id in
(select lessonid from lessonmessage where
public_er='sz')))A)
SQL动态的
print 'select top ' + convert(varchar,@pagesize)+' '+' * from '+' '+@TBname
+' where '+@keysname+' '+'in (select UserName from member1 where
lsb_team_id in
(select lessonid from lessonmessage where
public_er='+''''+@name+'''' +'))' +' and' +' '+@keysname+'<(select convert(varchar,min(id)) from( select top ' + convert(varchar,(@pageindex-1)*@pagesize)+' * from '+' '+@TBname+' where '+@keysname+' '+'in (select UserName from member1 where
lsb_team_id in
(select lessonid from lessonmessage where
public_er='+''''+@name+'''' +')))A)'
大于1的时候
得不到记录!