自定义博客皮肤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)
  • 收藏
  • 关注

原创 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 1369

转载 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 444

原创 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 1219

转载 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 442

原创 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 953

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

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

2015-05-15 12:19:34 1116 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 2952 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 880

原创 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 539

原创 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 471

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

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

2015-04-18 20:38:36 532

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

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

2015-04-17 23:28:32 17724 2

原创 怎样在报表中显示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 2082 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 1416

转载 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 664

翻译 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 2120

翻译 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 1673 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 1334

翻译 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 1514

转载 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 2619

转载 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 872

转载 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 1964

转载 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 1246

转载 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 1064

翻译 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 1263

翻译 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 1249

翻译 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 2402 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 1121

转载 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 1206

转载 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 1516 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 787

转载 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 1522

转载 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 727

原创 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 590

转载 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 2263 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 772

转载 [转贴]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 805

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

空空如也

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

TA关注的人

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