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.
```
Select COUNT(1) from ref_user where nm_user=@nm_user and password=@password;

```

This one returns the count value from `ref_user` table.

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

```

This one returns all [datas] values.