ALTER PROCEDURE MainInfo
@userID int,
@email nvarchar(30),
@password varchar(32),
@userName nvarchar(10),
@nickName nvarchar(20),
@question nvarchar(15),
@answer nvarchar(15),
@bankPassword varchar(32)
AS
insert into serLogin (userID,email,password) values (@userID,@email,@password)
insert into User(userID,userName,nickName,question,answer,bankPassword) values(@userID,@userName,@nickName,@question,@answer,@bankPassword)
@userID int,
@email nvarchar(30),
@password varchar(32),
@userName nvarchar(10),
@nickName nvarchar(20),
@question nvarchar(15),
@answer nvarchar(15),
@bankPassword varchar(32)
AS
insert into serLogin (userID,email,password) values (@userID,@email,@password)
insert into User(userID,userName,nickName,question,answer,bankPassword) values(@userID,@userName,@nickName,@question,@answer,@bankPassword)
语句已终止。
-->
insert into [User](userID,userName,nickName,question,answer,bankPassword) values(@userID,@userName,@nickName,@question,@answer,@bankPassword)
--因为有约束,把插入的顺序换下
ALTER PROCEDURE MainInfo
@userID int,
@email nvarchar(30),
@password varchar(32),
@userName nvarchar(10),
@nickName nvarchar(20),
@question nvarchar(15),
@answer nvarchar(15),
@bankPassword varchar(32)
AS
insert into User(userID,userName,nickName,question,answer,bankPassword) values(@userID,@userName,@nickName,@question,@answer,@bankPassword)
insert into serLogin (userID,email,password) values (@userID,@email,@password)