[Request] dbo.createAccount

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount]
@[Only registered and activated users can see links. Click Here To Register...] VARCHAR(15),
@[Only registered and activated users can see links. Click Here To Register...] VARCHAR(32)

AS

SET NOCOUNT ON

DECLARE @[Only registered and activated users can see links. Click Here To Register...]Activated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @[Only registered and activated users can see links. Click Here To Register...]) BEGIN
INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname)
VALUES @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], 'T', 'A', 'F')

SET @[Only registered and activated users can see links. Click Here To Register...]Activated = CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @[Only registered and activated users can see links. Click Here To Register...]Yesterday WHERE account = @[Only registered and activated users can see links. Click Here To Register...]
--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
-- VALUES @[Only registered and activated users can see links. Click Here To Register...], 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
VALUES @[Only registered and activated users can see links. Click Here To Register...], 'A000', '2', 'F', GETDATE(), @[Only registered and activated users can see links. Click Here To Register...]Activated, '20990101', '20050101', 'O')

END