THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Undocumented » Spool   (RSS)
  • A bug with Halloween Protection and the OUTPUT Clause

    Background The OUTPUT clause can be used to return results from an INSERT, UPDATE, DELETE, or MERGE statement. The data can be returned to the client, inserted to a table, or both. There are two ways to add OUTPUT data to a table: Using OUTPUT INTO With an outer INSERT statement. For example: -- Test table DECLARE @Target ...
    Posted to Page Free Space (Weblog) by Paul White on August 3, 2020
Privacy Statement