On the account part from the query below how do we create a user and password and is the User & PW have to be the same as the one "sa" or it could be different
how do you create a User & PW from this code, i am should on which parts should you change it bit confusing me
Code:
Use account;
Go
---Account Query By Warmonger---
DECLARE
userNO varchar(16),
accountID varchar(16),
PASsword varchar(32),
email varchar(50),
secretA varchar(22),
secretQ varchar(22)
SET
userNO= '09101410275532'
SET
accountID = 'Account ID'
SET
PASsword = 'Account Password'
SET
email = 'E-Mail'
SET
secretA = 'Secret Answer'
SET
secretQ = 'Secret Question'
Insert Into [USER_PROFILE] Values
userNO
accountID
PASsword,'801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')