Creating Complex Test Databases – Using Excel to convert a raw list of text into viable T-SQL syntax

As part of my series on creating databases with interesting characteristics for testing purposes, I have covered a few different engine constructs, test strategies, and scripting techniques to build interesting databases.  In this article, I am going to highlight one technique I use fairly often with leveraging Excel’s text concatenation functionality to generate T-SQL script…

4

Creating Complex Test Databases – Creating a Table with all Supported SQL Server Data Types

As part of my series on creating databases with interesting characteristics for testing purposes, today we’ll leverage the internal SQL Server system tables to create a table containing columns of each nullable and non-nullable data types supported by SQL Server. Goal:  Create a table that contains one column of every nullable data type and one column for…

1