SQL Server > Built in functions

Knowing SQL Server version in SQL Server

How to know the installed SQL Server name and version?


To get server name @@SERVERNAME and to get the version of SQL Server installed @@VERSION function can be used.

SELECT @@SERVERNAME, @@VERSION

Similarly, we can also use MAX connection allowed and max text size function like below

SELECT @@MAX_CONNECTIONS
SELECT @@TEXTSIZE

 Views: 1802 | Post Order: 65



Write for us