Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Mrbezawada Pilla Bewarse Username: Mrbezawada Post Number: 101 Registered: 10-2011 Posted From: 205.172.134.23 Rating: N/A Votes: 0 Posted on Thursday, October 15, 2015 - 10:58 am:    Krishna_jilla: DROP TABLE #Source CREATE TABLE #Source ( id INT IDENTITY , Flag NVARCHAR(10) ) INSERT INTO #Source VALUES ('Inserted'); INSERT INTO #Source VALUES ('Inserted'); INSERT INTO #Source VALUES ('Inserted'); SELECT * FROM #Source DECLARE @id INT SET @id = 3; IF EXISTS ( SELECT * FROM #Source WHERE id = @id ) UPDATE #Source SET Flag = 'Updated' WHERE id = @id ELSE INSERT INTO #Source VALUES ('Inserted') SELECT * FROM #Source Bezawada Bewarse Batchey