請問各位先進:
我用sql7.0 + vb6 測試一個非常簡單的storeProcedure
目的只為了把id的值sum起來內容如下:
table:
id int(4)
txt varchar(50)
storeprocedure:
CREATE PROCEDURE UP_test
AS
declare @val varchar(10)
set @val='id'
select SUM(@val) from table1
以上storeprocedure在檢查語法時出現下列錯誤訊息:
"error409:the sum of average aggregate operation
cannot take a varchar data type as an argument"
請問該如何修正才不會有此型態問題呢??
謝謝大家!!
我用sql7.0 + vb6 測試一個非常簡單的storeProcedure
目的只為了把id的值sum起來內容如下:
table:
id int(4)
txt varchar(50)
storeprocedure:
CREATE PROCEDURE UP_test
AS
declare @val varchar(10)
set @val='id'
select SUM(@val) from table1
以上storeprocedure在檢查語法時出現下列錯誤訊息:
"error409:the sum of average aggregate operation
cannot take a varchar data type as an argument"
請問該如何修正才不會有此型態問題呢??
謝謝大家!!
全站熱搜
留言列表