|
/*
alter procedure usp_qry_deficiency (@my_year as smallint,@my_month as smallint,@wage_pay_deficiency as money output)
as
select @wage_pay_deficiency = ((select sum(wage_sum) from wage where wage_date_year =@my_year and wage_date_month = @my_month) -(select sum(wage_sum) from wage where wage_date_year = @my_year and wage_date_month = @my_month and wage_pay = 1))
*/
SQL服務通過沒問題,但
declare @my_def as money
exec usp_qry_deficiency @my_year = 2002,@my_month = 8,@my_def output
select @my_def
執行時出錯如下:
Server: Msg 119, Level 15, State 1, Line 14
Must pass parameter number 3 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.
真不明,我以前都是這樣搞的,都沒出過錯,但今天真奇怪。請各位診斷一下,多謝! |
|