title: this is my stored procedure to check that there should n't same email id
body: <p>Here I need to get the message. If I enter email id in the application there I should get the message that email is already exists how it is possible?</p>
  
  <pre><code>IF not EXISTS(SELECT * FROM Resource WHERE Email= @Email)
  if(@status = 'Insert')
  BEGIN
       Insert into resource(FirstName,LastName,Password,Role,Email,Phone,OrganisationID) 
       values (@FirstName,@LastName,@Password,@Role,@Email,@Phone,@OrganisationID)
  END
  </code></pre>