alter procedure usp_qry_emp_enter_date @my_emp_sn as char(4),@@my_emp_enter_date as smalldatetime output as
select @@my_emp_enter_date = emp_enter_date from employee where mp_sn=@my_emp_sn
-----------------------------------------------------------------------------------
declare @@my_date as smalldatetime
exec usp_qry_emp_enter_date @my_emp_sn = 'g003',@@my_emp_enter_date=@@my_date output
select @@my_date
現在輸出參數多於一個時,該怎麼調用,高手指點一下:
alter procedure usp_qry_emp_enter_date
@my_emp_sn as char(4),@@my_emp_name as nvarchar(10) output,@@my_emp_enter_date as smalldatetime output as
select @@my_emp_name = emp_name,@@my_emp_enter_date = emp_enter_date from employee where emp_sn=@my_emp_sn
--------------------------------------------------------------
怎麼在查詢分析議中調用哪?怎麼在VBA中調用哪?多多謝!