CREATE TRIGGER test /* CHANGE TO ALTER when you edit this TRIGGER */
ON tbltest
FOR INSERT, UPDATE /* Fire this TRIGGER when a row IS INSERTed OR UPDATEd */
AS
BEGIN
                     UPDATE  tblTest  SET  tbltest.testvalue=tbltest.name 
                     FROM INSERTED
                     WHERE inserted.id=tbltest.id
END

 
/* Eg: */
INSERT INTO tblTest (name) VALUES (‘ooooo’) 
 
/* Now CHECK the DATA: */
SELECT *FROM tblTest