sqlserverÈÕÆÚÎÊÌâ - .NET¼¼Êõ / ASP.NET

±íA
id name time
1 '¶¼ÊÇ' 2010-03-22 00:42:47.293
2 '¶¼ÊÇ' 2010-04-22 00:43:33.187
3 '¶¼ÊÇ' 2010-04-23 00:43:37.280
4 '¶¼ÊÇ' 2010-05-22 00:43:39.450
5 '¶¼ÊÇ' 2010-06-22 00:43:40.543
6 '¶¼ÊÇ' 2010-07-22 00:43:41.560
7 '¶¼ÊÇ' 2011-04-22 00:43:47.107
8 '¶¼ÊÇ' 2012-04-22 00:43:50.293
9 '¶¼ÊÇ' 2013-04-22 00:43:59.950
10'¶¼ÊÇ' 2010-04-23 00:44:05.310
11'¶¼ÊÇ' 2010-04-22 00:44:07.170
12'¶¼ÊÇ' 2010-05-22 00:44:08.623

Ôõô¸ù¾ÝÈÕÆÚ²éѯ°¡ 

²éѯ2010ÄêµÄËùÓÐName
²éѯ2010Äê3ÔÂËùÓÐÊý¾Ý
²éѯ2010Äê3ÔÂ22ÈÕµÄËùÓÐÊý¾Ý

лл

---

select * from tb where month(time)=4
datepart

---

select name from ±íA where time between '2010-1-1' and '2010-12-31' 

select * from ±íA where time between '2010-3-1' and '2010-3-31'

select * from ±íA where time='2010-3-22'

---

1 select * from tb where time>=cast('2010' as datetime) and time<cast('2011' as datetime)
2 select * from tb where time>=cast('2010-3' as datetime) and time<cast('2010-4' as datetime)
3 select * from tb where time>=cast('2010-3-22' as datetime) and time<cast('2010-3-23' as datetime)

---

SQL code:
--²éѯ2010ÄêµÄËùÓÐName

select * from tb where year(time)=2010

--²éѯ2010Äê3ÔÂËùÓÐÊý¾Ý
select * from tb where year(time)=2010 and month(time)=