共通テーブル式(CTE)と再帰を使って書きます。
サンプルでは3行のデータを作成。
declare @num int = 3
;with CTE as
(
select 1 as A
union all
select A + 1 from CTE where A < @num
)
select *
from CTE
###実行結果
A
-----------
1
2
3
join してデータをn倍にしたい場合などに使うとよさそうです。
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme