[SQL ] 請教變數問題..
DBMS = MS SQL 2005
DECLARE @i int
SET @i = 100
WHILE @i <120
SELECT * FROM TABLE
WHERE 欄位名稱 = 'GD-'@i
SET @i=@i+1
請教一下 條件和變數 如合併存?
讓條件能變成
WHERE 欄位名稱 = GD-100 ~ GD120
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 60.251.182.25
→
02/25 01:20, , 1F
02/25 01:20, 1F
→
02/25 01:26, , 2F
02/25 01:26, 2F
→
02/25 11:26, , 3F
02/25 11:26, 3F
→
02/25 13:40, , 4F
02/25 13:40, 4F