2015年05月_土豆131421

06月 05月 04月 03月

转载 Oracle DDL 触发器

--1 在源库中创建捕获DDL的触发器与表--a--创建表create table ddl$trace(login_user varchar2(30),ddl_time date,program varchar2(64),schema_user varchar2(30),schema_object varchar2(30),ddl_sql varchar2(4000),id nu

2015-05-15 16:55:35 838

转载 How to run SSIS Project as a SQL Job

IntroductionIn Part 1 of this series, How to FTP a Dynamically Named Flat File, I explained how to create an SSIS Package that output a dynamically named flat file and then sent the output file

2015-05-13 16:52:01 853

转载 Temporary Stored Procedures

Temporary stored procedure is a little known feature of SQL Server. This article is an attempt to throw some light on this interesting feature.Temporary stored procedures are like normal stored p

2015-05-13 16:45:33 640

转载 Tips to Optimize Your SQL Statements - Part 1

IntroductionThere is a huge difference between writing an SQL statement which works and one which works well and performs well. Sometimes developers are too focused on just writing their SQL to pe

2015-05-13 16:32:58 474

转载 Tips to Optimize Your SQL Statements - Part 2

Tips to Optimize Your SQL Statements - Part 2By Brian Ellul, 2015/05/07IntroductionThis article can be considered the second part of my previous article, Tips to optimize your SQL Stat

2015-05-13 16:31:50 587

转载 How to FTP a Dynamically Named Flat File

IntroductionIn this article I explain how to create an SSIS Project that outputs a dynamically named flat file to a specified location using a variable and then sends the output file to a FTP serv

2015-05-13 16:25:11 1004

在SQL Server标准的已提交读（READ COMMITTED）隔离级别下，一个读操作会和一个写操作相互阻塞。未提交读（READ UNCOMMITTED）虽然不会有这种阻塞，但是读操作可能会读到脏数据，这是大部分用户不能接受的。有些关系型数据库（例如Oracle）使用的是另一种处理方式。在任何一个修改之前，先对修改前的版本做一个复制[WX1] ，后续的一切读操作都会去读这个复制的版本，修改将创

2015-05-06 10:30:38 670

转载 SQL Server FOR XML EXPLICIT 一步步学习

如果你使用的是SQL server 2000，你可以使用EXPLICIT控制建立你的XML结构。近来我在一些互联网论坛里帮助一些人解决在写TSQL时关于EXPLICIT的疑问。我观察到大多数程序员会因为FOR XML EXPLICIT的排序设置得到的结果问题而犯错。我和Vimal Rughani最近致力于解决这个问题。当我们搞定后，Vimal Rughani问我是不是可以把编写的过程写下来

2015-05-05 16:47:48 987