SQL Quiz #10 – The OUTPUT Clause
The OUTPUT clause is supported in T-SQL for modification statements, which you can use to return information from modified rows. This clause, even if not as popular as others, is useful in multiple scenarios, for example: for auditing purposes confirmation messages archiving your data It can be used to return information about every row affected Read More
SQL Quiz #9 – JSON Support
Hi all, Let’s start the week with an exciting new quiz. This quiz is related to the JSON support in SQL Server 2016.
How To #10 – Change the query behind “Edit Top 200 Rows”
SSMS is a great tool even with its default settings. However, it can be even greater if we are aware of some tweaks we can do to it. This is the second post of a longer series with tips related to SQL Server Management Studio. Our intention is to gather the most important settings we can perform Read More
How To #9 – View queries side by side with horizontal and vertical tabs
SSMS is a great tool even with its default settings. However, it can be even greater if we are aware of some tweaks we can do to it. This is the second post of a longer series with tips related to SQL Server Management Studio. Our intention is to gather the most important settings we can perform Read More
How To #8 – Enable word wrap and line numbers
SSMS is a great tool even with its default settings. However, it can be even greater if we are aware of some tweaks we can do to it. This is the first post of a longer series with tips related to SQL Server Management Studio. Our intention is to gather the most important settings we can Read More