Checking if parameter value exists in a table

[Freemo]

Hi,

I am passing a parameter value to a stored procedure and i would like to check whether this parameter value exists in a particular column of a particular table. I plan on returning different messages depending on whether it exists. Does anyone know how i can acheive this?

Many Thanks

 

[ca8msm]

You can use an if exists statement e.g.

if exists (select id from mytable where id = @myid)
  begin
    ...
  end
else
  begin
    ...
  end

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]