Usage of merge statement in sql

See more:

SQL

SQL-Server

SQL-Server-2008

Hello every one,

Iam using merge statement in sql studio 2008 and getting an error. please suggest me to use merge.

SELECT *FROM BAPU2
MERGE into bapu1 AS b1
using (select ID,VALUE from bapu2) AS b2
on b1.id = b2.id

when matched then update
set b1.value=b2.value

when not matched then insert

values(b1.id,b2.name,b3.value)

Error:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'into'.
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.