SQL Unit Testing reference guide for beginners
The post SQL Unit Testing reference guide for beginners appeared first on SQLServerCentral.
tSQLt
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) ...
The post SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types appeared first on SQLServerCentral.
SELECT DISTINCT SQL Command to Return a Unique List of ...
The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.
Build Conditional Logic – SQL IF, BEGIN, END, ELSE, ELSEIF
The post Build Conditional Logic – SQL IF, BEGIN, END, ELSE, ELSEIF appeared first on SQLServerCentral.
How to Build a Data Science Time Series Model with ...
The post How to Build a Data Science Time Series Model with SQL Server appeared first on SQLServerCentral.
Optimize Large SQL Server Insert, Update and Delete Processes by ...
The post Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches appeared first on SQLServerCentral.
INSERT EXEC statement cannot be nested, the Simple Solution
If you use the tSQLt unit testing framework for long enough, you will eventually run into the “An […]