As Rahul suggested you can check if a particular row exists in a table using
EXISTS (Transact-SQL)[
^]
Here is a sample
IF EXISTS (SELECT 1 FROM YourTable WHERE YourColumn = ValueToCheck)
BEGIN
END
ELSE
BEGIN
END
You write this in a stored procedure and pass the value to check as a parameter to the stored procedure.