CHECK WHETHER DUPLICATE EATERY

IF((SELECT COUNT(*) FROM TableName WHERE ColumnName=@ColumnName AND ColumnName1=@ColumnName1) > 0)
BEGIN   
 SELECT '! Exit'
 return
 END
 ELSE
 SELECT '! Not Exit'  

Write this code then we can't face duplicate entry