SQL Server 2008 Express で一撃で(ほぼ)1GBのテーブルをつくる

再帰クエリの応用例。

WITH
    T1 AS(
         SELECT
             1 SEQ,
             REPLICATE('X', 1024) TXT
         UNION ALL
         SELECT
             SEQ + 1 SEQ,
             TXT
         FROM
             T1
         WHERE
             SEQ < (1024 * 1024)
         )
SELECT
    TXT
    INTO T1GB
FROM
    T1
OPTION (MAXRECURSION 0)

Work! Enjoy it!

[追記]
OPTION (MAXRECURSION 0)
がないと100行でエラーになる...
http://msdn.microsoft.com/ja-jp/library/cc411406.aspx