UPDATE if exists else INSERT in SQL Server 2008

Question

In a stored procedure, for the same table i want to UPDATE if exists else INSERT data.
How ca this be implemented?

Answer 1

IF EXISTS(SELECT * FROM #Table WHERE id='211')
BEGIN
UPDATE #Table SET id = '200' WHERE (id='211')
END
ELSE
BEGIN
INSERT INTO #Table(id)VALUES('211')
END