Making Non-GM Account(Normal)

[esrever022]

I Wonder these Days how to make a Normal Account Using SQL Query anyone knows how to?

or What Do I Need To Change on This

DECLARE @RC int DECLARE @id varchar(13)
DECLARE @pw varchar(13)
DECLARE @depart varchar(32)
DECLARE @class varchar(12)
DECLARE @name varchar(12)
DECLARE @Birthday varchar(10)
DECLARE @Grade int
DECLARE @subgrade int
SELECT @id = 'Your Username'
SELECT @pw = 'Your Password'
SELECT @depart = 'none'
SELECT @class = 'GM'
SELECT @name = 'name'
SELECT @Birthday = 'None'
SELECT @Grade = 0
SELECT @subgrade = 0
EXEC @RC = [rf_user].[dbo].[pInsert_Staff] @id, @pw, @depart, @class, @name, @Birthday, @Grade, @subgrade
DECLARE @PrnLine nvarchar(4000)
PRINT 'Stored Procedure: rf_user.dbo.pInsert_Staff'
SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)

Is this Correct? Correct Me If Im Wrong(CMIIW)
Do I Need to change that "Grade" and "Subgrade" to 0

[MentaL]

[Bombillo]

GM Query

-- =============================================
-- Author:		Alejandro Gomez
-- Create date: 	13/09/2012 9:13:09 
-- Description:  	Account GM
-- =============================================

USE RF_USER Insert Into tbl_StaffAccount (ID,PW,Grade,Depart,RealName,SubGrade,Birthday,ComClass) 
Values (Convert(binary,'!Marlboro'),convert(binary,'ultrapower'),'2','none','teste','2','01/01/1991','GM')

Normal Query

-- =============================================
-- Author:		Alejandro Gomez
-- Create date: 	01/09/2012 12:30:07 
-- Description:  	Account Normal
-- =============================================

INSERT INTO RF_USER.dbo.tbl_rfaccount (Id,Password,accounttype,birthdate) 
VALUES ((CONVERT (binary(16),'A')),(CONVERT (binary(24),'A')),'0','01/01/1980')

[cobaltssfansX7]

GM Query

-- =============================================
-- Author:        Alejandro Gomez
-- Create date:     13/09/2012 9:13:09 
-- Description:      Account GM
-- =============================================

USE RF_USER Insert Into tbl_StaffAccount (ID,PW,Grade,Depart,RealName,SubGrade,Birthday,ComClass) 
Values (Convert(binary,'!Marlboro'),convert(binary,'ultrapower'),'2','none','teste','2','01/01/1991','GM')

Normal Query

-- =============================================
-- Author:        Alejandro Gomez
-- Create date:     01/09/2012 12:30:07 
-- Description:      Account Normal
-- =============================================

INSERT INTO RF_USER.dbo.tbl_rfaccount (Id,Password,accounttype,birthdate) 
VALUES ((CONVERT (binary(16),'A')),(CONVERT (binary(24),'A')),'0','01/01/1980')

where I need to insert new ID and password into the new GM account? here?

(Convert(binary,'!Marlboro'),convert(binary,'ultrapower')

or here?

(ID,PW,Grade,Depart,RealName,SubGrade,Birthday,ComClass)

sorry to post here, I just want to make sure before I really have to make a new thread just to ask this..

[Bombillo]

Inside the syntax ' ' by the order Id,Password,accounttype,birthdate that you see above