how can add user in sql 2008 or 2012

:rtfm: how can add user in sql 2008 or 2012

I TRAY THESIS CODE AND I GET PASSWORD INCINERATED CAN ANY ONE HELP ME PLZZZZZZZ

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 = 'ONE'
SET @Password = '123456'
SET @Email = '[Only registered and activated users can see links. Click Here To Register...]'
SET @SecretA = 'Answer'
SET @SecretQ = 'Question'

Insert Into [USER_PROFILE] Values (@UserNO,@AccountID,@Password,'801011000000','1',' 0','Y','10/10/2015 00:00:00',null,null,null,'000')