Wednesday, July 1, 2009

Get Server and Machine Name in SQL

 

 

To Get Server name in Microsoft Sql .

select @@SERVERNAME

 

To Get Machine name in Microsoft Sql .

select host_name()

 

No comments:

Post a Comment

Code Formater

Paste Here Your Source Code
Source Code Formatting Options
1) Convert Tab into Space :
2) Need Line Code Numbering :
3) Remove blank lines :
4) Embeded styles / Stylesheet :
5) Code Block Width :
6) Code Block Height :
7) Alternative Background :
Copy Formatted Source Code
 
Preview Of Formatted Code