- Joined
- Dec 18, 2009
- Messages
- 333
- Reaction score
- 142
SQL Query for newbie who want to input Premium Service and Cashshop manualy from SQL management Studio
Code:
/****** Script Owner : Hanry Roslaw Saputra ******/
/****** Created by : Hanry Roslaw Saputra ******/
/****** Tanggal Pembuatan : 18-07-2012 ******/
/****** Script ini hanya berlaku di 2.2.3.2 Golden Age ******/
DECLARE [USER=1333344765]name[/USER] VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE [USER=848971]Birth[/USER] smalldatetime
DECLARE [USER=213273]email[/USER] nvarchar(50)
DECLARE @status int
DECLARE [USER=315880]cas[/USER]h int
/****** Nama Loe ******/
SET [USER=1333344765]name[/USER] = 'nathan'
/****** Password Loe ******/
SET @pw = 'lingkungan'
/****** Tanggal Lahir Loe ******/
SET [USER=848971]Birth[/USER] = '07-22-1980'
/****** Email Loe ******/
SET [USER=213273]email[/USER] = 'natanael2207@gmail.com'
/****** Set 1 untuk jadi normal dan Set 2 untuk jadi premium ******/
SET @status = '2'
/****** Jumlah Cash yg mau di isi ******/
SET [USER=315880]cas[/USER]h = '1000000'
/************************************************************************************************************************************************/
BEGIN
INSERT INTO [RF_USER].[dbo].[tbl_rfaccount]
(
[id],
[password],
[birthdate],
[Email]
)
VALUES
(
CONVERT(BINARY(13) [USER=1333344765]name[/USER]),
CONVERT(BINARY(13),@pw),
[USER=848971]Birth[/USER],
[USER=213273]email[/USER]
)
INSERT INTO [BILLING].[dbo].[tbl_UserStatus]
(
[id],
[Status],
[DTStartPrem],
[DTEndPrem],
[Cash]
)
VALUES
(
[USER=1333344765]name[/USER],
@status,
CONVERT(datetime,GETDATE()),
CONVERT(datetime,GETDATE()+3),
[USER=315880]cas[/USER]h
)
END
/*************************************************************************************************************************************************/
Last edited: