MERGE for optional table updates on SQL Server

Description

Leverage the SQL Server MERGE command for handling optional secondary table updates which supports the full insert-update-delete spectrum

Activity

Show:
Sanne Grinovero
changed the StatusApril 5, 2023 at 8:05 AM
Resolved
Closed
Steve Ebersole
updated the DescriptionJanuary 27, 2023 at 5:38 PM
Leverage the SQL Server [MERGE|https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16] command for handling optional secondary table updates which supports the full insert, update and delete spectrum
Leverage the SQL Server [MERGE|https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16] command for handling optional secondary table updates which supports the full insert-update-delete spectrum
Steve Ebersole
updated the DescriptionJanuary 27, 2023 at 5:36 PM
[https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16|https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16|smart-link] Supports the full insert, update and delete spectrum
Leverage the SQL Server [MERGE|https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16] command for handling optional secondary table updates which supports the full insert, update and delete spectrum
Steve Ebersole
changed the StatusJanuary 26, 2023 at 6:42 AM
Open
Resolved
Steve Ebersole
updated the ResolutionJanuary 26, 2023 at 6:42 AM
None
Fixed
Steve Ebersole
updated the Fix versionsJanuary 26, 2023 at 2:35 AM
None
6.2.0
Steve Ebersole
changed the AssigneeJanuary 26, 2023 at 2:35 AM
Unassigned
Steve Ebersole
Steve Ebersole
updated the DescriptionJanuary 26, 2023 at 2:35 AM
None
[https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16|https://learn.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16|smart-link] Supports the full insert, update and delete spectrum
Steve Ebersole
changed the ParentJanuary 26, 2023 at 2:33 AM
None
HHH-16083
Steve Ebersole
updated the ParentJanuary 26, 2023 at 2:33 AM
None
HHH-16083
Steve Ebersole
changed the ParentJanuary 26, 2023 at 2:33 AM
None
HHH-16083
Steve Ebersole
created the IssueJanuary 26, 2023 at 2:33 AM
Fixed

Assignee

Steve Ebersole

Reporter

Fix versions

Priority

Created January 26, 2023 at 2:33 AM
Updated April 5, 2023 at 8:05 AM
Resolved January 26, 2023 at 6:42 AM