[SQL ] 請問關於迴圈(sql server 2008)

[valda (valda)]

目前用的DB是sql server 2008
之前都是使用oracle，也用得很習慣
，oracle可以靠connect by 跟 start
with做出以下的效果
select 1 as rn from dual
union all
select 2 as rn from dual
union all
select 3 as rn from dual
也就是說可以做出，1到3(變數)的迴圈，
請問在SQL SERVER 2008要如何實做出來呢？
感謝

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 123.204.229.82
→ chunhsiang:ORACLE是PL-SQL SQL SERVER查T-SQL吧
推 TeemingVoid:像這樣子嗎:
→ TeemingVoid:declare @t table (id int)
→ TeemingVoid:declare @i int
→ TeemingVoid:set @i = 1
→ TeemingVoid:while @i <= 3
→ TeemingVoid:begin
→ TeemingVoid:  insert into @t values (@i)
→ TeemingVoid:  set @i = @i + 1
→ TeemingVoid:end
→ TeemingVoid:select * from @t