top of page

Some basic queries In SQL Server

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.


Server Name

5, Retrieve Free Space of Hard Disk.

EXEC master..xp_fixeddrives 

Free Space

6. Get First Date of 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

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

8 views0 comments
bottom of page