stored procedure

Question

i want to write a stored procedure which will not allowed to insert  duplicate  value on two columns or multiples columns in sql server ,and at the time generating error how could i get that error on web page label