elite*gold: 73
Join Date: Sep 2008
Posts: 2,093
Received Thanks: 160
|
| USE [ACCOUNT_DBF] | | GO | | /****** Object: StoredProcedure [dbo].[webCreateAcc] Script Date: 08/17/2009 21:30:28 ******/ | | SET ANSI_NULLS ON | | GO | | SET QUOTED_IDENTIFIER ON | | GO | | CREATE PROCEDURE [dbo].[webCreateAcc] | | @account VARCHAR(15), | | @password VARCHAR(36), | | @email VARCHAR(120) | | AS | | SET NOCOUNT ON | | DECLARE @DateActivated AS CHAR(8) | | IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN | | INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) | | VALUES (@account, @password, @password, 'T', 'A', 'F') | | SET @DateActivated = CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1 | | --UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid | | --INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse) | | -- VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O') | | INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, email) | | VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O', @email) | | END | | --ELSE BEGIN | | --print '->Account exists = ' | | --print @account | | --END |
das per Mssql ausführen
|