如何在Sql Server 2008 R2中设计日历表？ [英] How to design a Calender table in Sql Server 2008 R2?.

问题描述

如何在Sql Server 2008 R2中设计日历表？就像我们有日历表而不是我可以存储工作日，假期，假期，周末。可以在一张桌子上设计所有这些吗？或者我需要一个主表和事务表？

How to design a Calender table in Sql Server 2008 R2?. Like if we have calender table than i can store the working days,leave days,Holidays, weekends. Is that possible to design all these in one table?. Or do i need a master and transaction tables?

推荐答案

有很多方法可以设计它，其中很大一部分取决于你想要支持多少功能。我建议你在白板上绘制需求，然后开始将它们映射到数据库表。或者，您也可以通过谷歌搜索其他人如何做到这一点的例子，但最终归结为您需要支持的内容。

There are many ways to design it and much of it depends on how much functionality you want to support. I suggest you draw on a white board the requirements and then start mapping those to database tables. Or, you can also google for examples to see how others have done it but in the end, it all comes down to what you need to support.

这篇关于如何在Sql Server 2008 R2中设计日历表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！