2011-02-24から1日間の記事一覧
再帰クエリの応用例。 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…