Some basic queries In SQL Server

Updated: Jun 23, 2019

1. Retrieve List of All Database

EXEC sp_helpdb 

List of All Database

2. Get the version name of SQL Server

SELECT @@VERSION AS Version_Name  

Server Version

3. Get Current Language of SQL Server

4. Return Server Name of SQL Server.

SELECT @@SERVERNAME AS 'Server_Name'

Server Name

5, Retrieve Free Space of Hard Disk.

EXEC master..xp_fixeddrives 

Free Space

6. Get First Date of Current Month

SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE()))+1,GETDATE()),105) First_Date_Current_Month;


Need any help in SqlServer Please contact us


If you like Codersarts blog and looking for Assignment help,Project help, Programming tutors help and suggestion you can send mail at contact@codersarts.com.


Please write your suggestion in comment section below if you find anything incorrect in this blog post

Contact Us

Tel: (+91) 0120  4118730  

Time :   10 : 00  AM -  08 : 00 PM IST 

Registered address: G-69, Sector 63, 

 Noida - 201301, India

We Provide Services Across The different countries

USA    Australia   Canada   UK    UAE    Singapore   New Zealand    Malasia   India   Ireland   Germany

CodersArts is a Product by Sofstack Technology Solutions Pvt. Ltd.

  • CodersArts | Linkedin
  • Instagram