Validate a register on SQL Server and C#

Question

I Have a Problem...

I have a variable on C#, it calls eRFCempresa. This variable gets a data from a xml file, and what I need to do, is:

In SQL Server Management, I want create a Stored Procedure, in this SP, I have to validate if the value stored in eRFCempresa exist in a Table.