Ò»¸ösqlÓï¾ä¡£

ÎÒÏë²é³ö
month
1
2
3
4
5
6
7
8
9
10
11
12
ÕâÑùµÄÊý¾Ý£¬ÈçºÎʵÏÖ°¡¡£¡£¡£

---

SQL code:

select top 12 month=identity(int,1,1) into #t from sysobjects

select * from #t



??

---

http://topic.csdn.net/u/20090906/17/a91cd31e-abf7-4190-8486-c5491aa63c71.html?seed=1380177511&r=59598572#r_59598572

---

SELECT * from (
SELECT 1 AS 'MONTH' UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 4 UNION ALL
SELECT 5 UNION ALL
SELECT 6 UNION ALL
SELECT 7 UNION ALL
SELECT 8 UNION ALL
SELECT 9 UNION ALL
SELECT 10 UNION ALL
SELECT 11 UNION ALL
SELECT 12 ) T

---

樓ÉÏÕý½â

---

ÎÒϲ»¶Ò»Â¥µÄ´ð°¸£¬£¬ÄÜ·ñ½âÊÍÒ»ÏÂÔ­Òò¡£¡£

---

MASTER..SPT_VALUES ÊÇϵͳ±í

SQL code:

select number from MASTER..SPT_VALUES where type='p' ---ÄãÖ´ÐÐÒ»ÏÂÕâ¸ö£¬¾ÍÖªµÀÁË

---

MASTER..SPT_VALUES ÊÇʲô

---

ÒýÓÃ

MASTER..SPT_VALUES ÊÇʲô

ϵͳ±í

---

select month('2009-09-09')µÃµ½ÔÂ·Ý ÊDz»ÊÇÒªÕâ¸ö¶«Î÷

---

select month(ÄãÒª²éµÄÈÕ