How can I write a stored procedure to select a value from a table and return that value??
I have a table Employee, when I send the email as a parameter to the stored procedure, I should get the employee number (it should return the employee number)
I am trying to execute the stored procedure in C# code.
I wrote a code but not sure about this and it is wrong how can I fix it
CREATE PROCEDURE dbo.getEmpID declare @empid int AS BEGIN /* SET NOCOUNT ON */ Select @empid From Employee Where Email=@empid END
appriciate if some one could guide me