hi, below is  my stored procedure. how to add an exception to it. thanks

create procedure addmember
 @ic nvarchar(40),
 @name nvarchr(40)
as
 insert into member (ic, name) values
      ('1234567', 'yls')

in regards to the above, how to add an exception when inserting an existing
ic number? thanks



---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com