Set @sql = 'select top 1 voiceName from Enterprise_FuncJK_' + rtrim(@biaoming) + ' where voicesort='''+ rtrim(@VoiceSort)+''' and id not in(select top 5 id from Enterprise_FuncJK_' + rtrim(@biaoming) + ' where voicesort='''+ rtrim(@VoiceSort)+''' order by dateCol DESC)
order by dateCol DESC'
order by dateCol DESC'
set @biaoming = 'biaoming'
set @VoiceSort='VoiceSort'
set @dTime='dTime'set @sql = 'select top 1 VoiceName from (select top 6 ' + 'VoiceName,'+rtrim(@dTime)+' as dTime from Enterprise_FuncJK_' + rtrim(@biaoming) + ' where VoiceSort=' +''''+ rtrim(@VoiceSort)+''''+' order by '+ rtrim(@dTime)+') as T_table order by dTime desc'
print @sql
T_table order by dTime desc'最后这个dTime ,其实是你的@dTime.
应该是T_table order by '+ @dTime +' desc'写错了意思你明白就好.