[求助]存储过程的问题
本人刚刚开始学习存储过程,写了个最简单的的,但执行的时候老师错误,提示是是where附近有语法错误,请知道的朋友帮个忙,指点下:
create procedure insert_stu
@stu_num varchar(50),
@stu_sex varchar(50),
@stu_race varchar(50),
@stu_degree varchar(50)
as
insert into ct_Stu
(
stu_sex,
stu_race,
stu_degree
)
values
(
@stu_sex,
@stu_race,
@stu_degree
)
where
stu_num=@stu_num
go