游標問題
ALTER procedure plxz @dept char(6),
@k_teacher char(8),
@k_mode char(20),
@k_task char(40),
@k_date char(16),
@k_grade char(10),
@k_add char(10)
as
declare @emp_code char(10)
declare @dept_code char(10)
declare @sex char(10)
declare @emp_name char(10)
declare @edu char(10)
declare @skill char(10)
declare @in_date char(10)
declare cur_plxz cursor for
select emp_code,dept_code,sex,emp_name,edu,skill,in_date from t_emp