- 博客(24)
- 资源 (11)
- 收藏
- 关注
转载 及物动词与不及物动词的区别
及物动词和不及物动词是动词的两种不同类型,许多学生使用时容易混淆,现加以区别。 及物动词,也称他动词,外动词,必须带宾语的动词和能够带受事宾语或关系宾语的动词。不及物动词,也称自动词,内动词,不能直接带宾语的动词和能带施事宾语的动词。 及物动词与不及物动词的根本区别是:及物动词能带宾语,如“他买菜”、“写书”、“挖洞”等;不及物动词不能直接带宾语。如“游行”、“出发”、“休息”等,就不能直
2014-12-22 15:23:44 3084
转载 ASP.NET 请求处理流程
http://www.cnblogs.com/xiaopin/archive/2010/08/26/1808956.html
2014-12-22 15:09:14 448
原创 a change of clothes
With only $40 in my pocket (and no credit cards), a backpack, a change of clothes and a toothbrush, I planned to find a job and earn enough money to get by. I am an able-bodied 41-year-old. Surely I c
2014-12-15 10:39:23 1085
原创 in/on the morning
on the morning of July 21 I took a Greyhound bus from Los Angeles to FresnoOn the morning of 28 February, we motored three hours out to seaYou do it in the morning
2014-12-15 10:16:20 661
原创 see firsthand亲眼看看
I wanted to see firsthand what that comeback looks like for many Californians我想亲眼看看对于加州人而言,“加州经济已复苏!”究竟是怎样一番景象1. I wanted to see firsthand 我想亲眼看看2. what that comeback looks like 加州经济
2014-12-15 10:10:42 687
原创 SQL 语句执行顺序
SELECT *FROM Tablewhere condition="a"group by ahaving count(a)>1order by a各子句在逻辑上按一下顺序处理:1、From2、 WHERE3、Group BY4、Having5、SELECT6、Order by
2014-12-09 15:09:11 360
原创 sharepoint服务器中切换用户帐号
Sharepoint服务器PS CodeEnter-PSSession //一次执行即可Enable-WSManCredSSP -Role Server -Force //一次执行即可Client PS CodeSet-Item wsman:\localhost\Client\TrustedHosts -value 192.168.0.* //一次执行即可$
2014-12-09 11:47:25 683
原创 ETL Architecture: 03 Create ProcessRecord Table
CREATE TABLE [dbo].[ETLSourceDataProcessRecord]([RecordID] [int] IDENTITY(1,1) NOT NULL,[SourceSystemKey] [int] NULL,[DataRangeStart] [nvarchar](40) NULL,[DataRangeEnd] [nvarchar](40) NULL,[
2014-12-05 11:56:08 401
原创 ETL Architecture: 02 Create Source Table
CREATE TABLE [dbo].[ETLSource]([SystemKey] [int] IDENTITY(1,1) NOT NULL,[SourceName] [nvarchar](50) NULL,[SystemName] [nvarchar](50) NULL,[SourceDescription] [nvarchar](100) NULL,[SystemDesc
2014-12-05 11:52:20 423
原创 ETL Architecture: 01 Create BathPool Table
CREATE TABLE [dbo].[ETLBatchPool]([BatchID] [bigint] IDENTITY(1,1) NOT NULL,[BatchStatus] [tinyint] NULL,[Generator] [nvarchar](100) NULL,[GenerateTime] [datetime] NULL,[ProcessStartTime] [d
2014-12-05 11:50:08 443
转载 OVER(PARTITION BY)函数用法
转自:http://www.cnblogs.com/lanzi/archive/2010/10/26/1861338.html
2014-12-05 11:29:08 431
原创 在明细表中做汇总
;WITH T AS (SELECT ROW_NUMBER() OVER(ORDER BY [SalesDate] DESC) AS ROWNUM,Amount,[SalesDate]FROM TempTableWHERE UserID=N'AA')SELECT A.ROWNUM,A.Amount,A.[SalesDate],(SELECT SUM(B.Amount) FR
2014-12-05 11:27:18 531
转载 包执行情况
select b.source as package,a.source as task,a.starttime,a.endtime,right(convert(varchar(19),a.endtime - a.starttime,120),8) durationfrom (select source,executionid,sourceid,MIN(ID) id,min(event)
2014-12-02 15:16:34 435
转载 查看SQL语句执行详情
--查询sqlserver 正在执行的sql语句的详细信息 --包含用户名,所在数据库,执行的sql语句,执行开始时间,驱动程序,主机名称SELECT [Spid] = session_Id, ecid, [Database] = DB_NAME(sp.dbid), [User] = nt_username, [Status] = er.status, [Wait] = wait_ty
2014-12-02 15:14:58 693
转载 转:rebuild索引
declare @objectid int,@indexid int,@partitioncount bigint,@schemaname sysname,@objectname sysname,@indexname sysname,@partitionnum bigint,@partitions bigint,@frag float,@command varchar(1000),@databas
2014-12-02 15:11:46 425
原创 SQL Server相关学习资料地址
1、SQL Server 2014新聚合columnstore索引介绍http://news.cnblogs.com/n/189427/2、SQLServer索引的四个高级特性http://blog.csdn.net/yzsind/article/details/87195943、 聚合索引(clustered index) / 非聚合索引(nonclustered index
2014-12-02 15:02:38 550
转载 转:SQL Server 查询性能优化——创建索引原则(一)
文章地址:http://www.cnblogs.com/chillsrc/archive/2012/09/19/2694313.html
2014-12-02 14:50:12 403
转载 转:知方可补不足~row_number,rank,dense_rank,ntile排名函数的用法
文章地址:http://www.cnblogs.com/lori/p/3340719.html
2014-12-02 14:49:14 437
原创 BI资料地址
1、微软BI 系列随笔列表 (SSIS, SSRS, SSAS, MDX, SQL Server) http://www.cnblogs.com/biwork/p/3328879.html2、SSRS 表达式 http://www.cnblogs.com/leoning/archive/2011/12/17/2290953.html3、Reporting S
2014-12-02 14:45:26 647
原创 MDX 函数库说明地址
http://msdn.microsoft.com/zh-cn/library/ms144866(v=sql.105).aspx
2014-12-02 14:36:09 389
原创 MDX语句之:ParallelPeriod
sum( ( ParallelPeriod([Date].[Calendar].[Month],35,[Date].[Calendar].currentmember) : [Date].[Calendar].currentmember ) , [Measures].[XXX度量] )sum((ParallelPeriod([Date].[Calendar].[Year],1,[Date].[C
2014-12-02 14:34:15 1805
原创 MDX语句
SELECT {[Measures].[XX度量]} ON COLUMNS, {nonempty(EXCEPT([A维度].[A].[A].ALLMEMBERS,{[A维度].[A].&[-1],[A维度].[A].[All].UNKNOWNMEMBER})) *except([B维度].[B].[B].ALLMEMBERS,{[B维度].[B].&[-1],[B维度].[B].[Al
2014-12-02 14:26:12 942
原创 SSRS报表中MDX语句数据集字段
WITH MEMBER [Measures].[ParameterCaption] AS [XXX维度].[XXX].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [XXX维度].[XXX].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLev
2014-12-02 14:21:53 1145
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人