Hello I am trying to insert some values into a table through a stored procedure. Which I can do, BUT then before the name goes into the table. I want it to check if that first/last name is already in the table? Then of course raise an error letting the user know the name is already in the tabe. Cheers for any help!
-- This is what I have so far --
Create Procedure AddCarrier (@CarrierFirstname varchar (30) = null, @CarrierLastName varchar (30) = null, @Phone char(10 = null) as if
-- End --