set @tmpSql='select '
set @tmpSql=@tmpSql+' fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special'
set @tmpSql=@tmpSql+' ,language,fileName,track,pTune,pStar,bh,dotStar,sbh,directory,isShow'
set @tmpSql=@tmpSql+'from'
set @tmpSql=@tmpSql+' iptv_new'
set @tmpSql=@tmpSql+'where'
set @tmpSql=@tmpSql+' 1=1'
if @FFileId<>''
begin
set @tmpSql=@tmpSql+' and fileid like '''%'+@FFileId+'%'''
end
set @tmpSql=@tmpSql+' fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special'
set @tmpSql=@tmpSql+' ,language,fileName,track,pTune,pStar,bh,dotStar,sbh,directory,isShow'
set @tmpSql=@tmpSql+'from'
set @tmpSql=@tmpSql+' iptv_new'
set @tmpSql=@tmpSql+'where'
set @tmpSql=@tmpSql+' 1=1'
if @FFileId<>''
begin
set @tmpSql=@tmpSql+' and fileid like '''%'+@FFileId+'%'''
end
set @tmpSql=@tmpSql+' fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special'
set @tmpSql=@tmpSql+' ,language,fileName,track,pTune,pStar,bh,dotStar,sbh,directory,isShow'
set @tmpSql=@tmpSql+'from'
set @tmpSql=@tmpSql+' iptv_new'
set @tmpSql=@tmpSql+'where'
set @tmpSql=@tmpSql+' 1=1'
if @FFileId<>''
begin
set @tmpSql=@tmpSql+' and fileid like ''%'+@FFileId+'%'''
end
set @tmpSql='select * from iptv_new'
exec(@tmpSql)反馈
服务器: 消息 2812,级别 16,状态 62,行 1
未能找到存储过程 's'。
decalre @tmpSql varchar
这样声明的@tmpSql等同与
decalre @tmpSql varchar(1)修改一下:decalre @tmpSql varchar(8000)