在create report 或往data grid中填充数据的时候,经常会遇到分页的需求,下面将列举两种常用的方法: 1,在查询的结果中添加一个identity(自动增长)列,并将整个结果集insert到另外一个临时表中: SELECT Identity(INT,1,1) AS RowNum, InspectionId, BoxId, IsFalseAlarm INTO #Temp FR
dtutil /file "D:\Program Files\Microsoft SQL Server\90\DTS\Packages\WF_Furnace_Shift_Data.dtsx" /COPY SQL;WF_Furnace_Shift_Data
1, How to create a linked server in SQL Server database Only SQL Server version has the ability to create a linked server Expand to the "Server Objects" Node, and there is
Today I found there were lots of logs record into the IIS log file in folder: System32\LogFiles\W3SVC1 Below is a part of these log data 2011-05-27 00:00:41 W3SVC1 127.0.0.1 POST /MSReportSe
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号