SQL Server Management Studio is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. Be it a T-SQL developer or DBA, we spend most of our time working on SSMS IDE. 

SSMS 17.2 is the latest version of SQL Server Management Studio. It provides support for almost all features on SQL Server 2008 through SQL Server 2017.

I have been using SSMS 2017 since its release. While writing some SQL scripts this morning, something caught my attention – and hence this quick blog post.

Do you recognize the below messages indicating the number of affected rows when you execute a SQL query?

(1 row(s) affected)

(2 row(s) affected)

Since the earlier versions of SQL Server, I found it amusing when I used to execute a query which returns just 1 row and it would display a message – (1 row(s) affected)

Over the years, I have been used to looking at similar messages –

However if you have SSMS 17.2 version installed, execute the same set of queries in SSMS 2017. You will see that the term rows(s) is no more displayed.

SQL Engine correctly displays ‘row’ or ‘rows’ messages based on the number of rows returned.

As a SQL developer, I see this as the smallest enhancement which could have been made – but it really makes sense and was long pending!

You can check out SQL Server Management Studio 17.2 Release Notes here.

Categories: SQL Server, SQL Server 2017