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