摘要：
http://technet.microsoft.com/en-us/library/aa259215%28SQL.80%29.aspxhttp://www.sqlusa.com/bestpractices/setdefaultlanguage/http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59051http://msdn.microsoft.com/en-us/library/ms187335.aspxhttp://msdn.microsoft.com/en-us/library/aa259642%28v=sql.80%29.aspx-- 阅读全文
摘要：
--SQL Server 2000-----Calendar Table Geovin Du 涂聚文declare @start datetime,@end datetimeset @start = '2006-01-01'set @end = '2006-05-02'declare @no_of_Days intset @no_of_days = datediff(dd,@start,@end) + 1set rowcount @no_of_daysselect identity(int,0,1) as dy into #temp from sysobject 阅读全文