hi
i want save user log into database
but insert duplicate record into database!
IF EXISTS [Username] = @Username AND [Password] = @Password
BEGIN
Login
END
ELSE
BEGIN
SET @OutPutMessage = 'Login Failed!'
IF EXISTS [Username] = @Username
BEGIN
INSERT INTO Log_Users
([UserId], [Date])
VALUES
((SELECT ID FROM UsersAccounts WHERE [UserName] = @UserName), (CURRENT_TIMESTAMP))
END
END
result:
ID UserId Date
1 49 2015-05-22 14:48:56.400
2 49 2015-05-22 14:48:56.453
how can i fix it?!
...
Go to the complete details ...