SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video

SQL SERVER - Get SQL Server Version and Edition Information - SQL in Sixty Seconds #043 - Video 60x60 What do consultants do when they come across any new instance of SQL Server? Well, their very first question is what version of SQL Server is it? The reason is simple – SQL Server is a very vast product and each version of the product have new features released and old features deprecated. Many consultant even remembers service pack and features released in it.

Well, there are multiple ways to know the version numbers of the SQL Server. In this sixty second video we will see a neat trick where we will quickly find the version number of SQL Server.

Let us see the same concept in following SQL in Sixty Seconds Video:

Related Tips in SQL in Sixty Seconds:

What would you like to see in the next SQL in Sixty Seconds video?

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5
Next Post
SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server

Related Posts

1 Comment. Leave new

  • Great tips. I did not know this “SERVERPROPERTY”.
    I want to add the old extended procedure: [xp_msver].

    Reply

Leave a Reply

Menu