更新SQLServer实例中所有数据库表的统计信息.docx
- 文档编号:8320542
- 上传时间:2023-01-30
- 格式:DOCX
- 页数:38
- 大小:25.37KB
更新SQLServer实例中所有数据库表的统计信息.docx
《更新SQLServer实例中所有数据库表的统计信息.docx》由会员分享,可在线阅读,更多相关《更新SQLServer实例中所有数据库表的统计信息.docx(38页珍藏版)》请在冰豆网上搜索。
更新SQLServer实例中所有数据库表的统计信息
更新SQLServer实例中所有数据库表的统计信息,工具类,直接复制进去,可以直接调用;Androi
谷歌IP来一盘。
赶快来享受美味,谷歌POI数据接口调用代码实例
谷歌POI数据接口调用代码实例,关闭win10升级提示,删除更新推送图标,关于Java核心技术学习积累的例子,是初学者及核,关于Thread.IsBackground属性的理解
[代码][SQL]代码
droptableifexists`group`;
createtable`group`(
`id`int(11)notnullauto_increment,
`parent_group_id`int(11)notnulldefault'-1',
`name`varchar(255)notnull,
primarykey(`id`)
);
insertinto`group`(`id`,`name`,`parent_group_id`)values(1,'a',-1);
insertinto`group`(`id`,`name`,`parent_group_id`)values(2,'b',-1);
insertinto`group`(`id`,`name`,`parent_group_id`)values(3,'c',1);
//Python解学军中学推理社2017届招新试题
//python利用or在列表解析中调用多个函数.py
//python模拟按键,自动翻页看u17漫画
/**
*返回树状结构表中指定节点的父节点路径.
*张露兵zhanglubing927@163
*2012-2-21
*/
dropprocedureifexistsget_path;
delimiter$
createprocedureget_path(inidint)
begin
declaregidintdefaultid;
declarepathvarchar(255)default'';
whilegidisnotnullandgid!
=-1do
selectconcat(concat(g.name,'(',g.id,')'),'-',path),g.parent_group_idintopath,gid
from`group`gwhereg.id=gid;
endwhile;
selectsubstring(path,1,length(path)-1)'path';
end
$
--callget_path(3);
#NAME?
//python将list连续元素和非连续元素分开
//python将list连续元素和非连续元素分开转换为
[代码]php导出excel文件并强制下载
php
header('Content-Type:
application/force-download');
header('Content-Disposition:
attachment;filename=租赁成交记录导出-'.date('y-m-d').'.xls');
echo'
asd | 123 |
qwe | 456 |
;
[代码]存储过程
--=============================================
--Author:
--Createdate:
55,> --Description: --============================================= CREATEproc[dbo].[procCountPV]( @ChannelIDnvarchar(50), @SourceIDint ) as begin declare@TEMIDint;--临时ID declare@Nowdatetime; set@Now=GETDATE(); declare@Ysmallint;--年 declare@Mtinyint;--月 declare@Wtinyint;--周 declare@Dtinyint;--日 declare@Htinyint;--小时 set@Y=DATEPART(YY,@Now); set@M=DATEPART(MM,@Now); set@W=DATEPART(WW,@Now); set@D=DATEPART(DD,@Now); set@H=DATEPART(HH,@Now); select@TEMID=[ID]from[PV]where[ChannelID]=@ChannelIDand[SourceID]=@SourceIDand[Y]=@Yand[M]=@Mand[D]=@Dand[H]=@H; if@TEMIDisnull Insertinto[PV]([ChannelID],[SourceID],[Times],[Y],[M],[W],[D],[H])values(@ChannelID,@SourceID,1,@Y,@M,@W,@D,@H); else Update[PV]set[Times]=[Times]+1where[ID]=@TEMID; /*计算现在*/ Declare@NowHourTimesint; Declare@NowDayTimesint; Declare@NowWeekTimesint; Declare@NowMonthTimesint; Declare@NowYearTimesint; --YMDH select@NowHourTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=@Yand[M]=@Mand[D]=@Dand[H]=@H; --YMD select@NowDayTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=@Yand[M]=@Mand[D]=@D; --YW select@NowWeekTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=@Yand[W]=@W; --YM select@NowMonthTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=@Yand[M]=@M; --Y select@NowYearTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=@Y; if@NowHourTimesisnull set@NowHourTimes=0; if@NowDayTimesisnull set@NowDayTimes=0; if@NowWeekTimesisnull set@NowWeekTimes=0; if@NowMonthTimesisnull set@NowMonthTimes=0; if@NowYearTimesisnull set@NowYearTimes=0; /*计算之前*/ Declare@PreHourTimesint; Declare@PreDayTimesint; Declare@PreWeekTimesint; Declare@PreMonthTimesint; Declare@PreYearTimesint; --YMDH Declare@PreHourDateTimedatetime; set@PreHourDateTime=DATEADD(HH,-1,@Now); select@PreHourTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=DATEPART(YY,@PreHourDateTime)and[M]=DATEPART(MM,@PreHourDateTime)and[D]=DATEPART(DD,@PreHourDateTime)and[H]=DATEPART(HH,@PreHourDateTime); --YMD Declare@PreDayDateTimedatetime; set@PreDayDateTime=DATEADD(DD,-1,@Now); select@PreDayTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=DATEPART(YY,@PreDayDateTime)and[M]=DATEPART(MM,@PreDayDateTime)and[D]=DATEPART(DD,@PreDayDateTime); --YW Declare@PreWeekDateTimedatetime; set@PreWeekDateTime=DATEADD(WW,-1,@Now); select@PreWeekTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=DATEPART(YY,@PreWeekDateTime)and[W]=DATEPART(WW,@PreWeekDateTime); --YM Declare@PreMonthDateTimedatetime; set@PreMonthDateTime=DATEADD(MM,-1,@Now); select@PreMonthTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=DATEPART(YY,@PreMonthDateTime)and[M]=DATEPART(MM,@PreMonthDateTime); --Y select@PreYearTimes=SUM([Times])from[PV]whereChannelID=@ChannelIDandSourceID=@SourceIDand[Y]=@Y-1; if@PreHourTimesisnull set@PreHourTimes=0; if@PreDayTimesisnull set@PreDayTimes=0; if@PreWeekTimesisnull set@PreWeekTimes=0; if@PreMonthTimesisnull set@PreMonthTimes=0; if@PreYearTimesisnull set@PreYearTimes=0; declare@HourRatefloat; declare@DayRatefloat; declare@WeekRatefloat; declare@MonthRatefloat; declare@YearRatefloat; set@HourRate=0; set@DayRate=0; set@WeekRate=0; set@MonthRate=0; set@YearRate=0; if@PreHourTimes>0 set@HourRate=(@NowHourTimes-@PreHourTimes)/(@PreHourTimes+0.0); if@PreDayTimes>0 set@DayRate=(@NowDayTimes-@PreDayTimes)/(@PreDayTimes+0.0); if@PreWeekTimes>0 set@WeekRate=(@NowWeekTimes-@PreWeekTimes)/(@PreWeekTimes+0.0); if@PreMonthTimes>0 set@MonthRate=(@NowMonthTimes-@PreMonthTimes)/(@PreMonthTimes+0.0); if@PreYearTimes>0 set@YearRate=(@NowYearTimes-@PreYearTimes)/(@PreYearTimes+0.0); /*计算总量*/ declare@Totalint; select@Total=SUM([Times])From[PV]whereChannelID=@ChannelIDandSourceID=@SourceID; if@Totalisnull set@Total=0; declare@TempIDint; set@TempID=null; /*操作CountSummary*/ Select@TempID=IDfrom[PVS]whereChannelID=@ChannelIDandSourceID=@SourceID; if@TempIDisnull Insertinto[PVS]([ChannelID],[SourceID],[HourRate],[HourTimes],[DayRate],[DayTimes],[WeekRate],[WeekTimes],[MonthRate],[MonthTimes],[YearRate],[YearTimes],[Total]) Values(@ChannelID,@SourceID,@HourRate,@NowHourTimes,@DayRate,@NowDayTimes,@WeekRate,@NowWeekTimes,@MonthRate,@NowMonthTimes,@YearRate,@NowYearTimes,@Total); else Update[PVS]set[HourRate]=@HourRate,[HourTimes]=@NowHourTimes,[DayRate]=@DayRate,[DayTimes]=@NowDayTimes,[WeekRate]=@WeekRate,[WeekTimes]=@NowWeekTimes,[MonthRate]=@MonthRate,[MonthTimes]=@NowMonthTimes,[YearRate]=@YearRate,[YearTimes]=@NowYearTimes,[Total]=@TotalwhereID=@TempID; end GO .[代码]PV表 CREATETABLE[dbo].[PV]( [ID][int]IDENTITY(1,1)NOTNULL, [ChannelID][int]NOTNULL, [SourceID][int]NOTNULL, [Times][int]NOTNULL, [Y][smallint]NULL, [M][tinyint]NULL, [W][tinyint]NULL, [D][tinyint]NULL, [H][tinyint]NULL, CONSTRAINT[PK_PV]PRIMARYKEYCLUSTERED ( [ID]ASC )WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY] )ON[PRIMARY] GO ALTERTABLE[dbo].[PV]ADDCONSTRAINT[DF_PV_Times]DEFAULT((0))FOR[Times] GO ALTERTABLE[dbo].[PV]ADDCONSTRAINT[DF_PV_Y]DEFAULT((2000))FOR[Y] GO ALTERTABLE[dbo].[PV]ADDCONSTRAINT[DF_PV_M]DEFAULT( (1))FOR[M] GO ALTERTABLE[dbo].[PV]ADDCONSTRAINT[DF_PV_W]DEFAULT( (1))FOR[W] GO ALTERTABLE[dbo].[PV]ADDCONSTRAINT[DF_PV_D]DEFAULT( (1))FOR[D] GO ALTERTABLE[dbo].[PV]ADDCONSTRAINT[DF_PV_H]DEFAULT((0))FOR[H] GO .[代码]PVS表 CREATETABLE[dbo].[PVS]( [ID][int]IDENTITY(1,1)NOTNULL, [ChannelID][int]NOTNULL, [SourceID][int]NOTNULL, [HourRate][float]NULL, [HourTimes][int]NULL, [DayRate][float]NULL, [DayTimes][int]NULL, [WeekRate][float]NULL, [WeekTimes][int]NULL, [MonthRate][float]NULL, [MonthTimes][int]NULL, [YearRate][float]NULL, [YearTimes][int]NULL, [Total][int]NULL, CONSTRAINT[PK_PVS]PRIMARYKEYCLUSTERED ( [ID]ASC )WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY] )ON[PRIMARY] GO [代码][Java]代码 packagesort; publicclassMergeSort{ publicstaticvoidmerge(int[]array,intstart1st,intstart2nd,intend2nd){ /* *cur1referstothefirstitemofa *cur2referstothefirstitemofb *cur3referstotheindexofthenextlocationoftemp */ int[]temp=newint[array.length]; intcur1=start1st,cur2=start2nd,cur3=start1st; /* *ifthereexistsacurrentiteminbothsequence *ifarray[cur1]<=array[cur2] *movearray[cur1]totherightendofcur3 *elsemovearray[cur2]totherightendofcur3 */ while((cur1 if(array[cur1]<=array[cur2]){ temp[cur3]=array[cur1]; cur1++; cur3++; }else{ temp[cur3]=array[cur2]; cur2++; cur3++; } } while(cur1 temp[cur3]=array[cur1]; cur1++; cur3++; } while(cur2<=end2nd){ temp[cur3]=array[cur2]; cur2++; cur3++; } cur1=start1st; cur3=start1st; while(cur3<=end2nd){ array[cur1]=temp[cur3]; cur1++; cur3++; } } /* *voidMergeSort(intarray[],intfirst,intlast)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 更新 SQLServer 实例 所有 数据库 统计 信息