Adding Accounts
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
Code:
Use account;
Go
Insert Into [TBL_USER] Values ('09101410275532', 'ID', 'Password', 'E-Mail', 'Secret Answer', 'Secret Question')
Insert Into [USER_PROFILE] Values ('09101410275532','ID','Password','801011000000',' 1','0','Y','01/01/2006 00:00:00',null,null,null,'000')
(NOTE: 09101410275532 Must Be Changed Atleast 1 Digit Per Account Added This Way)
i need to change ID,Password,Email,secret answer, and secret question right?but i had some error...
(1 row(s) affected)
Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_USER_PROFILE'. Cannot insert duplicate key in object 'USER_PROFILE'.
The statement has been terminated.
what is that error?