SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount]
[USER=162874]account[/USER] VARCHAR(15),
[USER=2000229135]pas[/USER]sword VARCHAR(32)
AS
SET NOCOUNT ON
DECLARE [USER=27358]date[/USER]Activated AS CHAR(8)
IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = [USER=162874]account[/USER]) BEGIN
INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname)
VALUES [USER=162874]account[/USER], [USER=2000229135]pas[/USER]sword, [USER=2000229135]pas[/USER]sword, 'T', 'A', 'F')
SET [USER=27358]date[/USER]Activated = CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = [USER=27358]date[/USER]Yesterday WHERE account = [USER=1335]user[/USER]id
--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
-- VALUES [USER=162874]account[/USER], 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')
INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
VALUES [USER=162874]account[/USER], 'A000', '2', 'F', GETDATE(), [USER=27358]date[/USER]Activated, '20990101', '20050101', 'O')
END