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

看板Database作者 (valda)時間13年前 (2012/06/20 21:32), 編輯推噓1(1推 0噓 10→)
留言11則, 2人參與, 最新討論串1/1
目前用的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
→
06/21 00:33, , 1F
ORACLE是PL-SQL SQL SERVER查T-SQL吧
06/21 00:33, 1F
推
06/21 02:14, , 2F
像這樣子嗎:
06/21 02:14, 2F
→
06/21 02:14, , 3F
declare @t table (id int)
06/21 02:14, 3F
→
06/21 02:14, , 4F
declare @i int
06/21 02:14, 4F
→
06/21 02:15, , 5F
set @i = 1
06/21 02:15, 5F
→
06/21 02:15, , 6F
while @i <= 3
06/21 02:15, 6F
→
06/21 02:15, , 7F
begin
06/21 02:15, 7F
→
06/21 02:15, , 8F
insert into @t values (@i)
06/21 02:15, 8F
→
06/21 02:16, , 9F
set @i = @i + 1
06/21 02:16, 9F
→
06/21 02:16, , 10F
end
06/21 02:16, 10F
→
06/21 02:16, , 11F
select * from @t
06/21 02:16, 11F
‣ 更多 valda 的文章
文章代碼(AID): #1FuT3p-V (Database)