Update Trigger Doubt?

If you want to return the updated information, you simply need to access the internal tables of the trigger:

CREATE TRIGGER BRTEST
ON WisePoints
AFTER UPDATE 
AS 
IF ( UPDATE (TotalPoints))
BEGIN
  SELECT TotalPoints as UpdatedTotalPoints 
  FROM inserted -- this is the list of new values that you just updated
END;

Be aware that this will return more than one row if more than one row is manipulated at once - e.g.

UPDATE WisePoints
SET TotalsPoints = TotalPoint + 10  -- add ten points to all records in the table

This will fire the trigger once, returning a result set of all new TotalPoints for the records in the table.

Inside triggers there are available inserted and deleted virtual tables.

For the AFTER UPDATE trigger the inserted virtual table contains all affected rows with new values. The deleted virtual table contain all affected rows with original values.

The triggers on MS SQL Server are fired once for all the affected records an you have a set of the affected records available in the virtual tables.