query select specific name - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

query select specific name

Author

Topic

megazi
Starting Member

6 Posts

Posted - 2013-06-04 : 22:13:00

How can i select specific computer name? Example i would like only information on DHAS-NB0034,client name & DPT.

object_client_name
------------------
Peter
John
Surez
Nancy

DPT
-------------------
HR
PROC
FIN
IT

Computer NAme
-------------------
DHAS-PC0321
DHAS-NB0021
DHAS-NB0034
DHAS-PC0001

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-06-04 : 23:39:10

i think select host_name()

EDIT: I haven't read post clearly...
--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-04 : 23:53:27

if i understand you correctly


SELECT *
FROM table
WHERE [Computer NAme]  = 'DHAS-NB0034'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources