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.

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