摘要:
--分区函数: [myPartFunc]CREATE TABLE [Calculate]( [id] [int] identity(1,1) , [name] [varchar](20) NULL, [val] [int] NULL, [cal] AS ([val]-(1)) PERSISTED)/*添加主键*//* 添加测试数据*/declare @rowCount intset @rowCount=1while @rowCount<4000001begin insert into [Calculate]([name],[val]) select 'Name_'+CAS 阅读全文