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

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

Samuel Lester - MSFT — Mon, 20 Aug 2012 15:41:58 GMT

Hi Mike, thanks for the feedback, I'll check that out. For the variant case, I had to actually include the hardcoded text on both sides of my data due to my final requirements since I needed my create table statement to include all variant data types in the following fashion:

sqlvariant_datetime2 sql_variant,

sqlvariant_datetimeoffset sql_variant,

sqlvariant_datetime sql_variant,

I'll try it out with your suggestion.

Thanks,

Sam

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

Mike Hayes — Mon, 20 Aug 2012 15:34:28 GMT

I've used a similar technique. Borrowing from your example above, the formula: = "('" & A1 & "','" & B1 & "')" will do the same thing, I think. I find it a little more easier to read - especially when I'm concatenating many cells of data.

Nice article.

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

Glenn Wilson — Mon, 13 Aug 2012 01:21:53 GMT

I have been using that function for a long time to create TSQL Text, works well and would be lost without it.. so quick to use.