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



UP! UP UP UP



fixed

sql query to look up account manually

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

 

[iElyrb]

USE UserLogin

Select * From account (Shows all accounts)

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