sql 分区函数

create partition function RangeTime (datetime)
 as range left for values ('2012-12-31','2013-12-31','2014-12-31')
 
 select $partition.RangeTime(1)

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

SELECT  * FROM  sys.sql_modules  WHERE object_id=object_id('SP_ActingDriveBillSelect')


sp_helptext'SP_ActingDriveBillSelect'
  
  
 SELECT  * FROM sys.objects WHERE type_desc='SYSTEM_TABLE'

 

posted @ 2015-10-19 14:26  hbsfgl  阅读(239)  评论(0编辑  收藏  举报