select 结果如何付给变量?
1. 如果结果是1个值:
SELECT @result=round(avg( Value),3)
FROM History
WHERE TagName like @p1+'%SR103'
AND Value>0
AND wwRetrievalMode = 'Cyclic'
AND wwCycleCount = 100
AND wwVersion = 'Latest'
AND DateTime >= @StartDate
AND DateTime <= @EndDate
2.结果为多个值:
declare @pp float
SELECT @pp=Value
FROM v_AnalogLive
LEFT JOIN QualityMap ON QualityMap.QualityDetail = v_AnalogLive.QualityDetail
WHERE TagName like 'CLFJJK1_00%JI802'
select @pp
这里将产生10个值,@pp的值为最后一个的值。