- 博客(21)
- 收藏
- 关注
RSS订阅Import/Export between Oracle and MySQL
把从Oracle数据库导出的数据导入到MySql数据库中1. 使用默认的结束符号导入到MySql数据库中:LOAD DATA LOCAL INFILE 'd:\oracle.txt' IGNORE INTO TABLE alarmLog 此时Fields的结束符默认的就是'\t'制表符，而不是"\t"字符串.2. 当设定Fields结束符导入到MySql数据库中:LOAD DATA LO...
2009-03-04 00:58:47
140
T-SQL - Using Trigger to monitor DML changes
1. Log tableIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[HotelOrder_OrderStatus_Log]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[HotelOrder_OrderStatus_Log](...
2009-03-04 00:22:11
116
T-SQL - Sync Table
/* --1---Create table---- */create table Sync_Table([id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,[Table_Name] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,CONSTRAINT [PK_Sync_Table] PRIMARY ...
2009-03-03 00:23:33
163
MySQL_Style - INSERT ... ON DUPLICATE KEY UPDATE
MySQL Performance BlogPar example, on vais creater une table pour noter le traffic de l'Internet, il y a une table avec le traffic et le numero de package de le port et l'IP de address.la table comme:...
2009-02-26 19:45:44
117
T-SQL - sp_executesql语法
--方法1查询表改为动态select * from sysobjects exec('select ID,Name from sysobjects') exec sp_executesql N'select ID,Name from sysobjects'--多了一个N为unicode--方法2:字段名，表名，数据库名之类作为变量时,用动态SQL declare @FName varchar(...
2009-02-25 00:41:46
143
T-SQL - 分页查询(ROW_NUMBER() OVER 语句)
DECLARE @rows_per_page AS INTEGERDECLARE @current_page AS INTEGERDECLARE @total_pages AS INTEGERDECLARE @start_item AS INTEGERDECLARE @items_count AS INTEGER-- 设置每页的行数SET @rows_per_page = 10-- 设置要显示的页...
2009-02-25 00:31:31
106
T-SQL - 拼脚本语句索引监控
use profiler to capture a server status for 24 hrs, the result stored into table Conn_AdminIII_2009_02_100. create indexCreate index idx_starttime on Conn_AdminIII_2009_02_10(starttime)1.SQL query:se...
2009-02-25 00:29:00
86
MySQL shell(ETPASS): M/S status, Sendmail
This script is actually another slow log detector, but it will also send mail instead of writing logs only.1. monitor MySQL, if the connection >= 30 then call the sendmail function---------------...
2009-01-19 22:18:47
113
Remotely disconnect a terminal services session
c:\ mstsc /v:Server IP /admin // on localc:\ tsadmin.exe // on target server, to kill some session, then reconnect by Remote DesktopYou have to cp tsadmin.exe from windows 2003's system32 to XPR...
2009-01-08 21:22:10
93
T-SQL creating folder
This StoredProcedure is using master.sys.xp_dirtree and master.sys.xp_create_subdir USE Master;GOSET NOCOUNT ON-- 1 - Variable declarationDECLARE @DBName sysnameDECLARE @DataPath nvarchar(500)DECLAR...
2009-01-06 19:53:08
82
T-SQL - Last Job Run Duration
select job_name, run_datetime,SUBSTRING(run_duration, 1, 2) + ':' + SUBSTRING(run_duration, 3, 2) + ':' +SUBSTRING(run_duration, 5, 2) AS run_durationfrom(select job_name, DATEADD(hh, -7, run_dateti...
2009-01-05 01:37:47
157
MySQL Index is slowing down the selecting actions
**Index is slowing down the selecting actions **Description the problem:Table size 30G, Ram size 16Gmysql> select * from program_access_log where program_id between 1 and 4000;very slowTry ...
2008-12-25 23:27:34
88
T-SQL - While Vs Cursor
Example 1:SELECT * INTO #t1 FROM dbo.HorseBaseDECLARE @id intDECLARE @t2 table (id int)WHILE (exists(SELECT HorseNumber FROM #t1))BEGINSELECT TOP 1 @id=HorseNumber FROM #t1INSERT INTO @t2 SELECT H...
2008-12-23 00:30:22
165
T-SQL - Using Trigger to monitor DDL changes
CREATE TABLE [DatabaseLog] (ID INT PRIMARY KEY IDENTITY(1,1),Command NVARCHAR(1000),PostTime NVARCHAR(24),[Event] NVARCHAR(100),[Schema] NVARCHAR(100),LoginName NVARCHAR(100),XmlEvent xml,[object] NVA...
2008-12-23 00:19:44
80
T-SQL - Delete&Truncate tables
1. Delete all tables DECLARE @tablename varchar(50)DECLARE @truncatesql varchar(255)DECLARE TrCun_Cursor CURSOR FORselect [name] from sysobjects where type = 'U'-- or select [name] from sysobjects wh...
2008-12-23 00:19:44
97
DB_Link between MSSQL05 and MySQL
DB_Link 基础：sp_addlinkedserver 'DB2'sp_setnetname 'DB2', 'ETMCDB'sp_helpserverselect * from OpenQuery(LINK_ETMCDB, 'select top 1 * from etmcdb.dbo.et_order order by PKID desc')select * from OpenQuery(D...
2008-12-09 23:54:09
104
.emacs
;;;;-------------------------显示中文(不应该配置，因为本为就已经支持中文，如果配置了会有打不开中文名文件的BUG)-------------------------;;(set-language-environment 'Chinese-GB);;(set-buffer-file-coding-system 'cn-gb-2312);;(set-keyboard-c...
2008-12-08 18:25:23
159
SQL Relay Setup
1. software env---------------Linux debian on both 2.6.18-5-686 and 2.6.18-5-amd64sqlrelay-0.39.4rudiments-0.31mysql-5.0.672. software installation------------------------$ ...
2008-11-22 01:51:52
121
原创 SQL Server 定时发送带附件的邮件
Create PROCEDURE [dbo].[job_AutoMail_xxd] ASBEGIN SET NOCOUNT ON;--获取数据truncate table Db_Name.dbo.Table_Nameinsert into Db_Name.dbo.Table_Name select * from openquery(Link_N
2008-10-07 17:26:00
3380
1
原创 SQL SERVER数据库字典
1. 显示表结构 SELECT TOP 100 PERCENT --a.id,CASE WHEN a.colorder = 1 THEN d.name ELSE END AS 表名,CASE WHEN a.colorder = 1 THEN isnull(f
2008-10-06 15:21:00
539
原创 Oracle中怎样将字段建成象SQL2000中的ID自动+1的字段
两种方法 方法一： 用触发器 建一个序列 create sequence a_seq increment by 1 start with 100; 建一个触发器, 自动+1 create or replace trigger your_seq_tri before insert on your_table1 for each row declare next_id number; begi
2007-08-24 10:42:00
599
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人