一句话:ghs.google.com又撞墙了
北京时间2009-3-24 19点!可恶的GWF!!
CREATE PARTITION FUNCTION [Month_Partition](int) AS RANGE
LEFT
FOR VALUES (1,2,3,4,5,6,7,8,9,10,11);
CREATE PARTITION SCHEME [Month_Scheme] AS PARTITION
[Month_Partition]
ALL TO ([PRIMARY]);
CREATE TABLE [dbo].[PT_Date](
[Month] [int] NOT NULL CONSTRAINT [DF_PT_Date_Month] DEFAULT (datepart(month,getdate())),
[Date] [datetime] NOT NULL
) ON [Month_Scheme]([Month]);
SELECT $partition.[Month_Partition]([Month]) as P, * FROM PT_Date
SELECT * From sys.partitions WHERE OBJECT_NAME(object_id) = 'PT_Date'
use master
sp_dropextendedproc 'xp_cmdshell'