Dynamic SQL Merge
This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.
2009-04-07
16,600 reads
Glen Schwickerath
Blogs
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
Azure chaos STUDIO
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Forums
Azure DW default schema in a query / proc equal to "Search_Path" in AWS
I know you can't do this in MSSQL, but hoping DW has progressed more....
Call SQL Agent job using different account to one executing powershell
Hi Folks trying the below but having zero luck and was wondering if anybody...
Encrypt Varchar(max) column in SQL Server
I have a varchar(max) column which has sensitive data and want to encrypt it....
Ask SSC