2010. 7. 29. 14:47
MSSQL Dummy 데이터 만들기 Work/SQL Server2010. 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);
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);