SQL SERVER 2008 r2

[Lunatic]

Hello Everyone . Just want to ask how to look up accounts individually on sql server 2008 r2 using query script?
Thanks

- - - Updated - - -

UP! UP UP UP

- - - Updated - - -

fixed :)

sql query to look up account manually

SELECT * FROM dbo.Account where UserID ='test.tad'

[MentaL]

[iElyrb]

USE UserLogin

Select * From account (Shows all accounts)

Select * from account where userid='username123' (shows username123's info)