Question: I want to know the actual difference b/w both select statements written in Stored Procedures??

```
Select COUNT(1) from ref_user where nm_user=@nm_user and password=@password;

```

and

```
   Select * from ref_user where nm_user=@nm_user and password=@password;

```

Please guide me proper as i am new to databases

Answer: 
One will return a count. The other will return the data.
The first query returns the Count of rows in the table where as the second query returns the entire rows from the table.