测一下你的t-sql 功力 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

测一下你的t-sql 功力

测一下你的t-sql 功力# Database - 数据库

z*y2009-12-08 08:12

1 楼

http://beyondrelational.com/blogs/tc/archive/2009/11/30/tsql-challenge-18-generate-
text-formatted-month-calendars.aspx

c*y2009-12-08 08:12

2 楼

厄
尝试一下
SQL Server 2008 Enterprise
declare @YY int;
declare @MM int;
set @YY = 2009;
set @MM = 11;
With CalenderCTE (DayNum,[Date],[WeekDay])
as(
select 1 as DayNum,
CONVERT(datetime,convert(nvarchar(8),@YY * 10000 + @MM * 100 + 1)) [
Date],
DATENAME(WEEKDAY,CONVERT(datetime,convert(nvarchar(8),@YY * 10000 +
@MM * 1
00 + 1))) [WeekDay]
union all
select Day(DATEADD(dd,1,[Date])) as DayNum,
DATEADD(dd,1,[Date]) as [Date],
DATENAME(WEEKDAY,DATE

【在 z***y 的大作中提到】

: http://beyondrelational.com/blogs/tc/archive/2009/11/30/tsql-challenge-18-generate-
: text-formatted-month-calendars.aspx

z*y2009-12-08 08:12

3 楼

你的code比我的好太多, 我奖给你100个包子.

【在 c*******y 的大作中提到】

: 厄
: 尝试一下
: SQL Server 2008 Enterprise
: declare @YY int;
: declare @MM int;
: set @YY = 2009;
: set @MM = 11;
: With CalenderCTE (DayNum,[Date],[WeekDay])
: as(
: select 1 as DayNum,

z*y2009-12-08 08:12

4 楼

if you could tweek your code regarding the collation requirement that would
be
perfect... Your current code is far better than mine...Great work!

【在 c*******y 的大作中提到】

: 厄
: 尝试一下
: SQL Server 2008 Enterprise
: declare @YY int;
: declare @MM int;
: set @YY = 2009;
: set @MM = 11;
: With CalenderCTE (DayNum,[Date],[WeekDay])
: as(
: select 1 as DayNum,

c*y2009-12-08 08:12

5 楼

厄，献丑了
谢谢你的包子
年月标题应该挺容易加的吧:)

would

【在 z***y 的大作中提到】

: if you could tweek your code regarding the collation requirement that would
: be
: perfect... Your current code is far better than mine...Great work!