- Joined
- May 21, 2011
- Messages
- 26
- Reaction score
- 0
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'secretquestion'.
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'secretanswer'.
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'birthday'.
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'regIP'.
I need to do
my usp_CreateNewAccount
//////////////////////////////////////////////////////////////////////////////////////////////////////////
USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[usp_CreateNewAccount] Script Date: 23/8/2562 16:57:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[usp_CreateNewAccount] account varchar(32),
@pw varchar(32), cash int = 0, email varchar(100) = ''
as
set nocount on
set xact_abort on
if not exists (select * from ACCOUNT_TBL where account = account)
begin
begin tran
INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,id_no2,realname,OldPassword, cash)
VALUES account, @pw, 'T', 'A', '', '', '', @pw, cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email)
VALUES account,'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, email)
insert AccountPlay (Account, PlayDate)
select account, convert(int, convert(char(8), getdate(), 112))
if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end
/////////////////////////////////////////////////////////
Invalid column name 'secretquestion'.
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'secretanswer'.
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'birthday'.
Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 20 [Batch Start Line 7]
Invalid column name 'regIP'.
I need to do
my usp_CreateNewAccount
//////////////////////////////////////////////////////////////////////////////////////////////////////////
USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[usp_CreateNewAccount] Script Date: 23/8/2562 16:57:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[usp_CreateNewAccount] account varchar(32),
@pw varchar(32), cash int = 0, email varchar(100) = ''
as
set nocount on
set xact_abort on
if not exists (select * from ACCOUNT_TBL where account = account)
begin
begin tran
INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,id_no2,realname,OldPassword, cash)
VALUES account, @pw, 'T', 'A', '', '', '', @pw, cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email)
VALUES account,'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, email)
insert AccountPlay (Account, PlayDate)
select account, convert(int, convert(char(8), getdate(), 112))
if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end
/////////////////////////////////////////////////////////