c＃中的sql命令 [英] sql command in c#

问题描述

我有一个数据表，其中包含日期为27-05-2013 ...

i可以通过搜索日期从表中获取数据..

现在我想要检查每月wais..like 05-2013 ..

如何进行这样的检查。

i having a datatable which contain date like 27-05-2013...
i can get data from table by searching with date..
now i want to check monthly wais..like 05-2013..
how can i do such a checking.

推荐答案

SELECT * FROM tbl
WHERE YEAR(DateColumn)=2013 AND MONTH(DateColumn)=05

这可能会对你有帮助

This may be help you

请参考下面的链接。它可以帮助你



http://www.aspdotnet-suresh.com/2012/11/sql-query-to-get-month-wise-data-year.html [<一个href =http://www.aspdotnet-suresh.com/2012/11/sql-query-to-get-month-wise-data-year.html\"target =_ blanktitle =新窗口> ^ ]



http://www.daniweb.com/web-development/databases/ms-sql/threads/389707/select-records-from-a-table-monthwise [ ^ ]

please refer below links. it may help u

http://www.aspdotnet-suresh.com/2012/11/sql-query-to-get-month-wise-data-year.html[^]

http://www.daniweb.com/web-development/databases/ms-sql/threads/389707/select-records-from-a-table-monthwise[^]

这篇关于c＃中的sql命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！