关于存储过程参数传递的问题

2005-06-21 11:35:29 163 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

华为昇腾310P3+deepseek蒸馏版性能调优：FP16精度优化全记录本文详细介绍了在华为昇腾310P3硬件环境下优化DeepSeek蒸馏版模型FP16精度的关键技术路径。通过分层量化策略、内存分配优化和并行计算配置，显著提升模型推理性能，实现83%的并发处理能力提升，同时保持98.7%的原始模型准确率。阅读详情

我要实现的功能是
if ClassEName <> "" then
HotNewsSql = "Select *,NewsClass.FileExtName as ClassFileExtName,News.FileExtName as NewsFileExtName from News,NewsClass where News.ClassID=NewsClass.ClassID and DelTF=0 and News.AuditTF=1 and NewsClass.ClassEName='" & ClassEName & "' order by News.ClickNum Desc"
else
HotNewsSql = "Select *,NewsClass.FileExtName as ClassFileExtName,News.FileExtName as NewsFileExtName from News,NewsClass where News.ClassID=NewsClass.ClassID and DelTF=0 and News.AuditTF=1 order by News.ClickNum Desc"
end if
我的存储过程是这样写的

CREATE Procedure FS_ReFunHotNews
(@ClassEName varchar(100))
as
begin transaction
declare @TempSql varchar(1500)
Set @TempSql='Select *,NewsClass.FileExtName as ClassFileExtName,News.FileExtName as NewsFileExtName from News,NewsClass where News.ClassID=NewsClass.ClassID and DelTF=0 and News.AuditTF=1'+@ClassEName+' order by News.ClickNum Desc'
exec(@TempSql)
if @@error=0
commit transaction
else
rollback transaction
return
GO
我要问的是
我怎么把参数 and NewsClass.ClassEName='" & ClassEName & "'传进去

或者改存储过程也行，怎么改？

...全文