Hi all
how to login system through sql server, there is a table contains column [useriId], [password],[active] for the userId is 10101 with the password "Welcome" and he is an active user .
so the users who r in active only can login to system , can anyone tell how to achive this
| UserId | Password | active |
| 10101 | Welcome | Y |
| 10102 | Welcome | Y |
| 10103 | Welcome | N |