关闭

及物动词与不及物动词的区别

及物动词和不及物动词是动词的两种不同类型,许多学生使用时容易混淆,现加以区别。  及物动词,也称他动词,外动词,必须带宾语的动词和能够带受事宾语或关系宾语的动词。不及物动词,也称自动词,内动词,不能直接带宾语的动词和能带施事宾语的动词。  及物动词与不及物动词的根本区别是:及物动词能带宾语,如“他买菜”、“写书”、“挖洞”等;不及物动词不能直接带宾语。如“游行”、“出发”、“休息”等,就不能直...
阅读(412) 评论(0)

ASP.NET 请求处理流程

http://www.cnblogs.com/xiaopin/archive/2010/08/26/1808956.html...
阅读(194) 评论(0)

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...
阅读(267) 评论(0)

in/on the morning

on the morning of July 21 I took a Greyhound bus from Los Angeles to Fresno On the morning of 28 February, we motored three hours out to sea You do it in the morning...
阅读(243) 评论(0)

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 加州经济...
阅读(264) 评论(0)

应聘互联网公司的简历应该是怎么样的?

转自:http://kb.cnblogs.com/page/505105/...
阅读(286) 评论(0)

SQL 语句执行顺序

SELECT * FROM  Table where condition="a" group by a having count(a)>1 order by a 各子句在逻辑上按一下顺序处理: 1、From 2、 WHERE 3、Group BY 4、Having 5、SELECT 6、Order by...
阅读(245) 评论(0)

sharepoint服务器中切换用户帐号

Sharepoint服务器PS Code Enter-PSSession  //一次执行即可 Enable-WSManCredSSP -Role Server -Force //一次执行即可 Client PS Code Set-Item wsman:\localhost\Client\TrustedHosts -value 192.168.0.*  //一次执行即可 $...
阅读(402) 评论(0)

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, [...
阅读(275) 评论(0)

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...
阅读(267) 评论(0)

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...
阅读(275) 评论(0)

OVER(PARTITION BY)函数用法

转自:http://www.cnblogs.com/lanzi/archive/2010/10/26/1861338.html...
阅读(276) 评论(0)

在明细表中做汇总

;WITH T AS (SELECT ROW_NUMBER() OVER(ORDER BY [SalesDate] DESC) AS ROWNUM ,Amount ,[SalesDate] FROM TempTable WHERE UserID=N'AA') SELECT A.ROWNUM,A.Amount,A.[SalesDate], (SELECT SUM(B.Amount) FR...
阅读(217) 评论(0)

包执行情况

select b.source as package,a.source as task,a.starttime,a.endtime,right(convert(varchar(19),a.endtime - a.starttime,120),8) duration from   (select  source,executionid,sourceid,MIN(ID) id,min(event)...
阅读(260) 评论(0)

查看SQL语句执行详情

--查询sqlserver 正在执行的sql语句的详细信息  --包含用户名,所在数据库,执行的sql语句,执行开始时间,驱动程序,主机名称 SELECT [Spid] = session_Id, ecid, [Database] = DB_NAME(sp.dbid),  [User] = nt_username, [Status] = er.status, [Wait] = wait_ty...
阅读(291) 评论(0)

转:rebuild索引

declare @objectid int,@indexid int,@partitioncount bigint,@schemaname sysname,@objectname sysname,@indexname sysname,@partitionnum bigint,@partitions bigint,@frag float,@command varchar(1000),@databas...
阅读(227) 评论(0)

SQL Server相关学习资料地址

1、SQL Server 2014新聚合columnstore索引介绍 http://news.cnblogs.com/n/189427/ 2、SQLServer索引的四个高级特性 http://blog.csdn.net/yzsind/article/details/8719594 3、 聚合索引(clustered index) / 非聚合索引(nonclustered index...
阅读(338) 评论(0)

转:SQL Server 查询性能优化——创建索引原则(一)

文章地址:http://www.cnblogs.com/chillsrc/archive/2012/09/19/2694313.html...
阅读(256) 评论(0)

转:知方可补不足~row_number,rank,dense_rank,ntile排名函数的用法

文章地址:http://www.cnblogs.com/lori/p/3340719.html...
阅读(295) 评论(0)

BI资料地址

1、微软BI 系列随笔列表 (SSIS, SSRS, SSAS, MDX, SQL Server)       http://www.cnblogs.com/biwork/p/3328879.html 2、SSRS 表达式       http://www.cnblogs.com/leoning/archive/2011/12/17/2290953.html 3、Reporting S...
阅读(379) 评论(0)
148条 共8页1 2 3 4 5 ... 下一页 尾页
    个人资料
    • 访问:114050次
    • 积分:1624
    • 等级:
    • 排名:千里之外
    • 原创:37篇
    • 转载:111篇
    • 译文:0篇
    • 评论:3条
    文章分类
    最新评论