CREATE TRIGGER  New_User
ON  tblAdmin
AFTER INSERT 
AS

DECLARE
@AdminRECID uniqueidentifier,
@CreateUser varchar(50),
@CreateDate datetime,
@AuditUser varchar(50),
@AuditDate datetime,
@MenuRECID uniqueidentifier
BEGIN
SELECT RECID = @AdminRECID,
	   CreateUser = @CreateUser,
	   CreateDate = @CreateDate,
	   AuditUser  = @AuditUser,
	   AuditDate  = @AuditDate
FROM tblAdmin;

SELECT RECID = @MenuRECID
FROM tblMenu;


INSERT INTO tblAdmin_Access(RECID,AdminRECID,MenuRECID,Status,CreateUser,CreateDate,AuditUser,AuditDate)
	VALUES ((newid()),@AdminRECID,@MenuRECID,'A',@CreateUser,@CreateDate,@AuditUser,@AuditDate);


END;

delimiter $$

CREATE TRIGGER  New_User AFTER INSERT ON  tblAdmin

FOR EACH ROW
BEGIN
DECLARE _AdminRECID char(36);
DECLARE _CreateUser varchar(50);
DECLARE _CreateDate datetime;
DECLARE _AuditUser varchar(50);
DECLARE _AuditDate datetime;
DECLARE _MenuRECID CHAR(36);

SELECT RECID = _AdminRECID,
	   CreateUser = _CreateUser,
	   CreateDate = _CreateDate,
	   AuditUser  = _AuditUser,
	   AuditDate  = _AuditDate
FROM tblAdmin;

SELECT RECID = _MenuRECID
FROM tblMenu;



	INSERT INTO tblAdmin_Access(RECID,AdminRECID,MenuRECID,Status,CreateUser,CreateDate,AuditUser,AuditDate)
	VALUES (UUID(),_AdminRECID,_MenuRECID,'A',_CreateUser,CURDATE(),_AuditUser,CURDATE());


END;