Create procedure insertuserinfo
(
@username varchar(20),
@userpwd varchar(20),
@usercompany varchar (50),
@usertel char (20),
@useraddress char (30),
@useremail char (10),
@userfax char (10)
)
as
if exists
(
select username
from userinfo
where username = @username
)
return 1
else
insert userinfo ( username,userpwd,usercompany,usertel,useraddress,useremail
,userfax)
values ( @username,@userpwd,@usercompany,@usertel,@useraddress,@useremail
,@userfax)
(
@username varchar(20),
@userpwd varchar(20),
@usercompany varchar (50),
@usertel char (20),
@useraddress char (30),
@useremail char (10),
@userfax char (10)
)
as
if exists
(
select username
from userinfo
where username = @username
)
return 1
else
insert userinfo ( username,userpwd,usercompany,usertel,useraddress,useremail
,userfax)
values ( @username,@userpwd,@usercompany,@usertel,@useraddress,@useremail
,@userfax)
@username varchar(20),
@userpwd varchar(20),
@usercompany varchar (50),
@usertel char (20),
@useraddress char (30),
@useremail char (10),
@userfax char (10),
as
as
if exists
(
select username
from userinfo
where username = @username
)
return 1
else
insert userinfo ( username,userpwd,usercompany,usertel,useraddress,useremail
,userfax)
values ( @username,@userpwd,@usercompany,@usertel,@useraddress,@useremail
,@userfax)