- 1. Copy a table with structure and data into a temporary table
- / Transact-SQL /
- ... (dummyIndex INT); -- Alter temporary table structure to match given table SET @TableDeclaration='ALTER TABLE #myScrambledTable ADD ' + STUFF( ( -- Code to concatenate column names and data ...
- Created on 03 August 2012