insertrecord 存储过程.txt

ASP+SQL Server动态网站开发从基础到实践教程

CREATE PROCEDURE InsertRecord
@UserID varchar(15),
@UserPWD varchar(15),
@UserName varchar(20),
@Birth smalldatetime,
@Diploma varchar(15),
@TelPhone varchar(13),
@CellPhone varchar(11),
@IDCard varchar(18),
@Province varchar(10),
@City varchar(15),
@Gender varchar(2),
@PassQuestion varchar(10),
@PassAnswer varchar(20),
@HomePage varchar(30),
@Address varchar(50),
@PostCode varchar(6)

AS 
begin

declare @bExists int
if exists(select UserID from register where UserID=@UserID)
	select @bExists = 1
else
begin
	select @bExists = 0
insert into register (UserID,UserPWD,UserName,Birth,Diploma,TelPhone,CellPhone,IDCard,Province,City,Gender,PassQuestion,PassAnswer,HomePage,Address,PostCode) values (@UserID,@UserPWD,@UserName,@Birth,@Diploma,@TelPhone,@CellPhone,@IDCard,@Province,@City,@Gender,@PassQuestion,@PassAnswer,@HomePage,@Address,@PostCode)
end
	return @bExists
end
GO