CREATE TABLE CreatingAccount(
idCreatingAccount INT IDENTITY (1, 1) NOT NULL PRIMARY KEY,
userFirstName VARCHAR (20) NOT NULL,
userLastName VARCHAR (20) NOT NULL,
userName VARCHAR (20) NOT NULL,
userPassword VARCHAR (20) NOT NULL,
userEmail VARCHAR (50) NOT NULL,
userGender VARCHAR (5) NOT NULL
);
GO

CREATE TRIGGER ToCreateALogin ON CreatingAccount
FOR INSERT
AS
DECLARE @user VARCHAR (20)
DECLARE @pass VARCHAR (20)

SELECT @user = i.userName FROM inserted i;
SELECT @pass = i.userPassword FROM inserted i;

INSERT INTO LoggingIn (loggingUserName, loggingUserPasword)
    VALUES (@user, @pass)

PRINT 'THE USER HAS BEEN ADDED SUCCESSFULLY'
GO

INSERT INTO LoggingIn (idCreatingAccount, loggingUserName, loggingUserPasword)
    VALUES (@idCreatingAccount, @user, @pass)

CREATE TRIGGER ToDeleteALogin ON CreatingAccount
FOR DELETE
AS

delete li
from LoggingIn li
join deleted d
  on d.loggingUserName = li.userName;

PRINT 'THE USER HAS BEEN DELETED SUCCESSFULLY'
GO

CREATE TRIGGER ToDeleteALogin ON CreatingAccount
FOR DELETE
AS

delete li
from LoggingIn li
join deleted d
  on d.idCreatingAccount = li.idCreatingAccount;

PRINT 'THE USER(S) HAVE BEEN DELETED SUCCESSFULLY';
GO

delete from CreatingAccount where idCreatingAcount in (1,2,3);

insert into CreatingAccount (userFirstName, userLastName, ..., userGender)
select userFirstName, userLastName, ..., userGender
  from algunaTabla;

insert into CreatingAccount (userFirstName, userLastName, ..., userGender)
values
('Juan', 'Manuel, ..., 'H'),
('Julia', 'Soto', ..., 'M');

CREATE TRIGGER ToCreateALogin ON CreatingAccount
FOR INSERT
AS

INSERT INTO LoggingIn (loggingUserName, loggingUserPasword)
SELECT userName, userPassword
  FROM inserted;

PRINT 'THE USER(S) HAVE BEEN ADDED SUCCESSFULLY';
GO