自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(37)
  • 资源 (2)
  • 论坛 (95)
  • 收藏
  • 关注

原创 PowerShell:Power Shell 安装

Windows Power Shell是微软提供给系统管理员和IT人员的一个外壳工具和脚本运行环境,可以通过编程实现对系统的自动化管理和操作。 Power Shell最初的代号是Monad,也成为Microsoft Shell (MSH),是参考UNIX的SHELL模式,基于Windows平台下的内建脚本语言以及辅助脚本程式的工具。从2003年的第一个beta版本发布开始,微软不断的更新并完善Po

2015-06-17 15:24:21 1052

转载 T-SQL:zz检查文件夹下的文件大小

原文:Check Up Size Of Each Folder In a Path,版权归原作者. 贴过来备用:USE [DB_Maint]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF OBJECT_ID(N'[dbo].[usp_Folder_Size_Check]') IS NOT NULLBEGIN DROP PROCEDUR

2015-06-11 20:38:11 417

原创 SSRS:报表开发中的一些小技巧

1.文本多行显示的处理方法。 参考SSRS: Multiple Ways to Split a String into Multiple Lines (1) 使用VB的换行符 VBCRLF (2)使用ASCII码的转换符 CHR(10) (3)使用HTML的转换符 BR 值得注意的是,在使用HTML转换符时,需要该控件支持HTML属性,设置对应的控件的HTML属性, 例子:-- VBCR

2015-06-10 22:44:52 1061

转载 T-SQL:[zz]SQL Server NOLOCK Hint & other poor ideas.

今天逛论坛看到问NOLOCK的问题,搜到MSDN上有一篇比较好的文章,转载到这里。留爪! SQL Server NOLOCK Hint & other poor ideas

2015-05-29 21:03:08 412

原创 T-SQL: GROUP BY

GROUP BY的用法:GROUP BY (Transact-SQL) -- Declare Table variable.. DECLARE @tbA TABLE ( ID INT NOT NULL IDENTITY(1,1) ,

2015-05-26 11:42:29 877

原创 SSRS:按月汇总的动态表头实现-Matrix Control

前言: 工具是为实现需求服务的。不同的工具提供了不同的方式,在选择过程中,选择最优最快的实现方式,这是一个成熟的码农必备的技能。本篇参考了CodeProject上的这篇文章:Using SSRS - Matrix Control to Generate Columns Dynamically 场景:SQL Server 2012 AdventureWorks2012 数据库。 目的:实现按照用

2015-05-15 12:19:34 963 1

原创 SSRS:如何消除SSRS报表导出EXCEL出现的合并列和隐藏列

在SSRS报表开发中,经常会遇到报表导出为EXCEL格式的文档。而SSRS导出过程中,由于报表本身设计的问题,导致导出的EXCEL文档中会出现合并列或者隐藏列。本文将介绍几种常见的消除SSRS报表导出EXCEL出现的合并列和隐藏列的方法。文中的方法参考了MSDN的Blog:How to eliminate merged and hidden Cells issue from Excel Export

2015-05-13 20:33:28 2350 1

原创 T-SQL: JOIN的几种关系

SQL Server提供了多种JOIN机制,在联机丛书FROM (Transact-SQL)中列举了四种JOIN操作.1.INNER JOIN(交集) INNER JOIN在数学上是指两个集合的交集,数学符号∩。如下图所示,图中红色部分则为INNER JOIN的结果。 例如: {1, 2} ∩ {1, 2} = {1, 2}. {1, 2} ∩ {2,

2015-04-23 00:31:25 706

原创 T-SQL:取最值的几种方式的简单比较.

通常情况下,都会遇到取最值的情况,T-SQL提供了多种方式实现最值比较,简单罗列几种。 1. NOT EXISTSUSE [AdventureWorks2012];GODBCC FREEPROCCACHE;GOSET STATISTICS PROFILE ON;SET STATISTICS IO ON;SET STATISTICS TIME ON;SELECT DISTINCT

2015-04-19 01:13:11 486

原创 T-SQL:提取第一次出现的数字组合

问题:提取任意字符串中第一次出现的数字组合。USE [AdventureWorks2012];GODECLARE @t_TB TABLE( ColVal VARCHAR(20));INSERT INTO @t_TB VALUES ('ABC123'), ('ENA329'), ('EEE22W33'), ('F1W2C3E8'), ('DDDDDDD'

2015-04-19 00:32:33 428

转载 怎么判断某个库中的某张表在某个时间段有没有被使用过

今天逛论坛,遇到一个经常问的问题,怎么判断某个库中的某张表在某个时间段有没有被使用过?记得以前在Aaron Bertrand的Blog上看到过,去翻一翻,找到了转过来.When was my database / table last accessed? 里面提到了几种方法,列举如下: 1.使用SQL Server审计功能,通过审计功能的记录看判断对应的数据库对象的最后访问时间。USE mas

2015-04-18 20:38:36 413

转载 学习SQL Server推荐的10本书

今天在sqlmag上闲逛,看到了这篇一年前写的文章,正好在看其中的一本,推荐给大家。原文地址:Top 10 Highly Recommended SQL Server Books.

2015-04-17 23:28:32 12314 1

原创 怎样在报表中显示HTML/RTF内容系列之二-将HTML内容存储为RTF格式

首先声明,本系列从本节开始,没有特别说明的情况下均是以SQL Server 2005和Reporting Service 2005为基础展开的讨论。将HTML内容存储为RTF格式,在基于.NET架构下有很多免费和付费控件可以参考,有基于JavaScript编写的,也有基于WinForm下的RichTextBox集成的。如下简单介绍几种常见的Web页面下使用的RichTextBox.1) F

2009-10-21 10:58:00 1964 1

原创 怎样在报表中显示HTML/RTF内容系列之一-SSRS 2008中显示HTML内容

怎样在报表中显示HTML/RTF内容系列-SSRS 2008中显示HTML内容SSRS 2008中显示HTML内容? 在一些报表项目中需要使用到对HTML内容的展示,本系列主要阐述SSRS 2005中怎样显示HTML/RTF内容的主要步骤和实现方式。但是对于SSRS 2008已经支持的技术而言,本文将简述针对SSRS 2008对HTML内容的显示,在后续的系列中将重点阐述SSRS 2005

2009-10-15 11:48:00 1253

转载 zz 0ffice 2007 something.....

1.安装 Office 2007时勿输入序列号; 2.安装完成,不要运行 Word、Excell 等任何 Office 程序组件; 3.进入目录:C:/Program Files/Common Files/Microsoft Shared/Office 12/Office Setup Controller/Proof.en;找到此 xml 文件,用记事本打开编辑: 将语句中的 AlwaysInst

2009-06-09 00:01:00 624

翻译 Reporting Services 2005 for the DBA – Reporting Services Encryption 2 of 2

Author: Steve Chowles  http://sqlblogcasts.com/blogs/stevechowles/archive/2007/08/28/reporting-services-2005-for-the-dba-reporting-services-encryption-2-of-2.aspx This is the second part of my t

2008-05-24 11:42:00 2084

翻译 Reporting Services 2005 for the DBA – Reporting Services Encryption 1 of 2

 Author:Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/08/14/reporting-services-2005-for-the-dba-reporting-services-encryption-1-of-2.aspx If you understand how Reporting

2008-05-22 23:47:00 1640 1

翻译 Reporting Services 2005 for the DBA – IIS Security

Author:stevechowleshttp://sqlblogcasts.com/blogs/stevechowles/archive/2007/06/08/reporting-services-2005-for-the-dba-iis-security.aspx This is the second part of my IIS article which today covers II

2008-05-20 21:45:00 1296

翻译 Reporting Services 2005 for the DBA – IIS

Author:stevechowleshttp://sqlblogcasts.com/blogs/stevechowles/archive/2007/06/08/reporting-services-2005-for-the-dba-iis.aspx One of the most misunderstood aspects of Reporting Services is how it fi

2008-05-20 19:52:00 1468

转载 Sarbanes-Oxley compliance checklist: IT security and SQL audits

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312646,00.html?track=NL-416&ad=637013&asrc=EM_NLT_3610732&uid=6118215Michelle Gutzait05.07.2008Problem:  My company needs to meet Sar

2008-05-10 09:06:00 2549

转载 Using Reporting Services to Search the SQL Server Log

http://www.sqlservercentral.com/articles/Reporting+Services/62934/By Carolyn Richardson, 2008/05/06 Total article views: 4172 | Views in the last 30 days: 4172  Rate this |   Join the discussio

2008-05-10 09:02:00 840

转载 Create DDL table in SQL Server 2005 to audit DDL trigger activity

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312369,00.html?track=NL-417&ad=638703&asrc=EM_NLT_3593059&uid=6118215Robert Sheldon05.05.2008Prior to SQL Server 2005, you could define

2008-05-10 08:59:00 1918

转载 More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions

http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/More-SQL-Server-2005-Solutions.aspx#38351Jeff Smith I previously wrote about a few of the new features in SQL 2005 and how they can be used to s

2008-05-09 12:58:00 1227

转载 Importing Excel data with SQL Server Integration Services and dealing with unicode and non-unicode data issues

http://www.mssqltips.com/tip.asp?tip=1393 SSIS中关于Unicode和Non-Unicode的转换,主要是添加Data Convertion 控件来转换即可,注意CodePage的属性,需要设置启用默认的codepage为True.

2008-05-03 11:11:00 1052

翻译 Reporting Services 2005 for the DBA – Changing Application Pool Identity

http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-changing-application-pool-identity.aspxAuthor:Steve Chowles报表服务DBA系列之应用程序缓存池身份更改 By default

2008-04-29 22:39:00 1228

翻译 Reporting Services 2005 for the DBA – Connectivity Issues

Reporting Services 2005 for the DBA – Connectivity Issues 报表服务之DBA系列 –关于连接 http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-connectivity-issues.a

2008-04-27 22:36:00 1216

翻译 Reporting Services 2005 for the DBA – Double Hop Authentication

By : Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/03/reporting-services-2005-for-the-dba-double-hop-authentication.aspx One of the issues which crop up time and time agai

2008-04-16 00:21:00 2372 2

转载 Concatenating row values in Transact-SQL

http://www.projectdmx.com/tsql/rowconcatenate.aspxBy Umachandar Jayachandran, Linda Wierzbecki, Bruce Margolin, Roy Harvey, Eugene Kogan, Vadim Tropashko, Anub Philip.

2008-04-13 12:07:00 1072

转载 Custom Auto-Generated Sequences with SQL Server

 http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-serverBy Jeff SmithThis article by Jeff Smith covers different ways to create sequence numbers. It starts with the basic id

2008-04-13 11:37:00 1178

转载 Find Nth maximum value in SQL Server

http://www.sqlteam.com/article/find-nth-maximum-value-in-sql-serverBy Guest Authors on 11 April 2004 | 13 Comments | Tags: SELECT  This aritlce is written by Hariharan Velayuthan. He writes

2008-04-10 21:52:00 1497 2

转载 To SP or not to SP in SQL Server: an argument for stored procedures

  http://www.simple-talk.com/sql/t-sql-programming/to-sp-or-not-to-sp-in-sql-server-an-argument-for-stored-procedures/The database-as-API approachBy Adam MachanicThis article is adapted from Ada

2008-04-09 21:10:00 671

转载 How to check Fragmentation on SQL Server 2005

http://blogs.msdn.com/jorgepc/archive/2007/12/09/how-to-check-fragmentation-on-sql-server-2005.aspxAuthor: jorgepc  I have been asked this question several times: Is there a tool in SQL Server whe

2008-04-09 21:07:00 1490

转载 Document Sarbanes-Oxley compliance with SQL Server 2005

 http://blogs.techrepublic.com.com/datacenter/?p=323&tag=nl.e046    Author: Tim Chapman As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Ox

2008-04-08 21:03:00 702

原创 Batch update table name using *sp_rename*

扩展存储过程sp_rename的使用方法:sp_rename [ @objname = ] object_name , [ @newname = ] new_name     [ , [ @objtype = ] object_type ]  USE [DATABASENAME]GODECLARE @i intDECLARE @count intDECLARE 

2008-04-08 14:11:00 568

转载 SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained

http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspxSQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explainedThe dust has n

2008-04-02 10:32:00 2208 2

转载 Stored procedures: Find columns and tables

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1109458,00.htmlthe author: Brian Walker is a senior database architect in an IS department that uses SQL Server 2000 and the .NET Framewor

2008-03-28 21:55:00 739

转载 [转贴]How do I find a stored procedure containing ?

http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.htmlI see this question at least once a week. Usually, people are trying to find all the stored procedures that

2008-03-28 21:33:00 776

SSRS: 动态表头的Matrix实现的源代码

SSRS:动态表头的Matrix实现,Blog原文:http://blog.csdn.net/hery2002/article/details/45743057

2015-05-15

EliminateMergedAndHiddenCells

SSRS 报表消除Excel中的隐藏行和列的示例,Blog原文:http://blog.csdn.net/hery2002/article/details/45697777

2015-05-13

阔别多年,今天上来晃晃,发现~~~

发表于 2015-04-18 最后回复 2015-06-06

年前散个分,年后好化缘!

发表于 2012-01-18 最后回复 2015-04-18

藏经阁第1卷-SQL常见的安装问题

发表于 2008-07-20 最后回复 2012-09-27

藏经阁第2卷-SQL常用的函数

发表于 2008-08-03 最后回复 2012-05-15

[]我要求查看change history。。。。

发表于 2011-12-26 最后回复 2012-01-28

好久没来了~~~~混个脸熟.

发表于 2010-10-29 最后回复 2011-08-11

签到帖!

发表于 2009-10-01 最后回复 2011-07-15

[翻译]几篇Steve Chowles 关于SSRS 2005 DBA的文章!

发表于 2008-05-24 最后回复 2011-04-08

日前云游到乐山,膜拜了一下乐山大佛.大家都来拜拜.....

发表于 2010-06-21 最后回复 2010-06-29

如果我没有记错......

发表于 2010-04-01 最后回复 2010-06-24

散个分,明天回成都了.

发表于 2010-03-20 最后回复 2010-03-22

过年了....

发表于 2010-02-11 最后回复 2010-02-18

过年了,小散一把!

发表于 2009-12-30 最后回复 2010-01-03

2009/12/21

发表于 2009-12-21 最后回复 2009-12-22

SS走了,影子生了,老羊隐了,小梁升了......

发表于 2009-11-03 最后回复 2009-12-18

好久没来了...

发表于 2009-09-18 最后回复 2009-09-19

每天挂在CSDN上好不好?

发表于 2008-07-24 最后回复 2009-08-14

24 Hours of FREE, Nonstop SQL Server Training

发表于 2009-08-10 最后回复 2009-08-14

人到中年,更年期---烦!散分

发表于 2009-08-05 最后回复 2009-08-05

【强制结贴公告】SQL基础版从2009年6月15号起,不定期地对发帖时间超过半年的帖子而未结的帖子进行强制结贴的公告!

发表于 2009-06-04 最后回复 2009-08-02

【基础版之强制结贴申诉帖】

发表于 2009-06-17 最后回复 2009-07-06

[向基础版提问]关于基础版的帖子结贴给分问题!

发表于 2008-07-18 最后回复 2009-06-11

成都,9路起火了....哎~24人....

发表于 2009-06-05 最后回复 2009-06-05

半年了,终于等到回眸一笑~

发表于 2009-05-25 最后回复 2009-06-01

查岗!

发表于 2009-05-28 最后回复 2009-05-28

向两位新上任的版猪祝贺!:)

发表于 2009-03-30 最后回复 2009-05-13

周末,成都CSDN俱乐部,三圣乡喝茶,版里面有人去么?

发表于 2009-04-23 最后回复 2009-04-27

见到了很多人,呵呵

发表于 2009-04-19 最后回复 2009-04-20

又一个钻钻诞生了....GXGX!

发表于 2009-03-30 最后回复 2009-04-06

最近好像很多人都升了,wufeng4552,Garnett_KG......

发表于 2008-10-23 最后回复 2008-10-28

恭喜Roy_88申版成功!:)

发表于 2008-10-17 最后回复 2008-10-23

又生了~ gx 梁MM~

发表于 2008-10-21 最后回复 2008-10-23

冒个泡,回水里去了~

发表于 2008-10-15 最后回复 2008-10-16

NetAdvantage 2008 v1.0的效率问题.

发表于 2008-06-26 最后回复 2008-10-09

几位进来接分!unsigned,wufeng4552,liangCK,sdhylj!:)

发表于 2008-09-07 最后回复 2008-09-08

新任板猪!gxgx!

发表于 2008-09-04 最后回复 2008-09-05

祝贺 sdhylj 升板猪!:)

发表于 2008-09-01 最后回复 2008-09-04

化缘专用贴!:)

发表于 2008-08-27 最后回复 2008-08-27

SQLnewlearner ,请进 :) 关于object同名问题.

发表于 2008-08-04 最后回复 2008-08-27

惊闻疯子升星,散分以贺之!:)

发表于 2008-08-25 最后回复 2008-08-27

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人 TA的粉丝

提示
确定要删除当前文章?
取消 删除