MERGE for optional table updates on SQL Server
Description
Activity
Show:
Sanne Grinovero
changed the StatusApril 5, 2023 at 8:05 AMResolved
Closed
Steve Ebersole
updated the DescriptionJanuary 27, 2023 at 5:38 PMLeverage 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 AMOpen
Resolved
Steve Ebersole
updated the ResolutionJanuary 26, 2023 at 6:42 AMNone
Fixed
Steve Ebersole
updated the Fix versionsJanuary 26, 2023 at 2:35 AMNone
6.2.0
Steve Ebersole
changed the AssigneeJanuary 26, 2023 at 2:35 AMUnassigned
Steve Ebersole
Steve Ebersole
updated the DescriptionJanuary 26, 2023 at 2:35 AMNone
[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 AMNone
HHH-16083
Steve Ebersole
updated the ParentJanuary 26, 2023 at 2:33 AMNone
HHH-16083
Steve Ebersole
changed the ParentJanuary 26, 2023 at 2:33 AMNone
HHH-16083
Steve Ebersole
created the IssueJanuary 26, 2023 at 2:33 AMFixed
Assignee
Reporter
Steve Ebersole
Steve EbersoleFix 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
Leverage the SQL Server MERGE command for handling optional secondary table updates which supports the full insert-update-delete spectrum