改为CREATE procedure useradd
@UID varchar(50),
@UPassword varchar(50),
@UQuestion varchar(50),
@UAnswer varchar(50),
@USex bit,
@UCityID int,
@Email varchar(50)
as
insert into Users(UID,UPassword,UQuestion,UAnswer,UPower,USex,UCityID,Email) values
(@UID,@UPassword,@UQuestion,@UAnswer,2,@USex,@UCityID,@Email)
GO