注册帐号

图片：QQ截图未命名.png

怎么没有webCreateAcc 额？

= =

本帖最后由 daijinhai520 于 2011-8-31 12:04 编辑

建立个记事本 .txt

复制   粘贴进  记事本  然后改名字 和扩展名   webcreateacc.sql

在进
1.打开 SQL Server Management Studio Express
2.点击数据库 ACCOUNT_DBF
3.可编辑性
4.储存过程

这里双击 刚刚创建的  webcreateacc.sql  这样就有了..  


直线以下复制
_____________________________________________________________

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(32),
        @password         varchar(32),
        @email                varchar(100)

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

谁能帮我远程坐下V15中文版的！跪求！QQ1508994243！！！！！做的好可能有点利。！！！

谁能帮我远程做下V15中文版的！跪求！QQ1508994243！！！！！