MERGE STATEMENT IN SQL SERVER

DECLARE @TEST TABLE(DATA VARCHAR(20),ID INT)

INSERT INTO @TEST VALUES('RAJU',1)

INSERT INTO @TEST VALUES('RANI',2)

INSERT INTO @TEST VALUES('MANU',3)

DECLARE @MERGTEST TABLE(DATA VARCHAR(20),ID INT)

INSERT INTO @MERGTEST VALUES('RAJU',1)

INSERT INTO @MERGTEST VALUES('RANI',2)

INSERT INTO @MERGTEST VALUES('JONSON',4)

SELECT 'NON MERGED TABLE TEST',* FROM @TEST

SELECT 'NON MERGED TABLE MERGTEST',* FROM @MERGTEST

MERGE INTO @TEST AS TEST

USING(SELECT DATA,ID FROM @MERGTEST) AS MERGTEST(DATA,ID)

ON TEST.DATA=MERGTEST.DATA AND TEST.ID=MERGTEST.ID

WHEN NOT MATCHED BY TARGET THEN

INSERT(DATA,ID) VALUES(MERGTEST.DATA,MERGTEST.ID);

SELECT 'MERGED TABLE TEST',* FROM @TEST

ABS() FUNCTION IN SQL SERVER

The ABS function is used for return positive value of numeric expression or to remove Minus value from
numeric expression.

Passing Negative value to  ABS Function

SELECT ABS(-123.25)   ---Output  123.25

Passing Positive value to  ABS Function                                

SELECT ABS(123.25)  ---Output  123.25