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

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

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

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