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
