Using @@Rowcount

Giganews Newsgroups
Subject: Using @@Rowcount
Posted by:  Bob (Go13…@Yahoo.Com)
Date: Tue, 1 May 2012


I'm writing a s proc to authenticate users.

So I want to see if there is 1 record "....where UserID='somevalue'
and Password='someothervalue'

if the @@rowcount is 1 then i want to return a 1 from the sp,
otherwise I want to return a 0

Can you help?