Work/SQL Server

MSSQL Dummy 데이터 만들기

Elick 2010. 7. 29. 14:47
-- 90 일 날짜 만들기
WITH Dumy 
AS

 SELECT GETDATE() DT  
 UNION ALL
 SELECT DT + 1 FROM Dumy 
 WHERE DT + 1 < DATEADD(day, 90, GETDATE())

SELECT CONVERT(varchar(10), DT, 121) DT
FROM Dumy 
OPTION (MAXRECURSION 0);

-- 10까지 숫자 만들기
WITH Dumy 
AS

 SELECT 0 Seq 
 UNION ALL
 SELECT Seq + 1 FROM Dumy 
 WHERE Seq + 1 <= 10 

SELECT Seq FROM Dumy 
OPTION (MAXRECURSION 0);