EricQLiu-CSDN博客

原创 SQL Server-查询区分大小写

1.区分大小写--一笔记录 select * from hph where row_id COLLATE CHINESE_PRC_CS_AS='AAAoOTAAMAAABJTAAM'; 2.不区分大小写--两笔记录 select * from hph where row_id COLLATE CHINESE_PRC_Ci_AS='AAAoOTAAMAAABJTAAM';

2011-01-04 15:38:00 624

原创 Oracle常用脚本-监控DDL

acle常用脚本-监控DDL

2011-01-04 15:30:00 865

原创 Oracle常用脚本-监控DDL

CREATE TABLE db_ddl (ddl_time VARCHAR2(30), session_id NUMBER, os_user VARCHAR2(200), ip_address VARCHAR2(200), terminal

2010-12-30 12:58:00 740

原创 Oracle常用脚本-每个表使用了多少空间

CREATE OR REPLACE VIEW db_table_used ( segment_name, used_mb ) AS SELECT segment_name, SUM (BYTES) / 1024 / 1024 as Used_MB FROM user_extents GROUP BY segment_name order by Used_MB desc /

2010-12-30 12:57:00 430

原创 Oracle常用脚本-查看表空间使用情况

CREATE OR REPLACE VIEW db_used AS select b.file_id　　, 　　b.tablespace_name　　, 　　b.file_name　　　　　, 　　b.bytes　/1024/1024　　　　　　total_mb, 　　(b.bytes-sum(nvl(a.bytes,0)))/1024/1024　　　used_mb, 　　sum(nvl(a.bytes,0))/1024/1

2010-12-30 12:56:00 561

原创 Oracle常用脚本-查看哪些对象被Lock

CREATE OR REPLACE VIEW db_lock ( username, lock_level, owner, object_name, object_type, sid, serial#, terminal, machine, program, osuser ) AS SELECT /*+

2010-12-30 12:55:00 1170

原创 JS 遍历GridView DropDownList

function CheckData(gridId, sysDateList) { //sysDateList Ex: QTY:20100613|QZB:20100102 try { var arraySiteDateList=sysDateList.split("|"); var grid = document.getElementById(gridId); var siteDate=0; //Row1:Gro

2010-06-12 11:57:00 1103

原创 Oracle Export,Import

1.导出(1)语法exp @userid/@password@@tnsname grants=n owner=@schema_name file=@schema_name.dmp log=@schema_name.exp.log帮助 exp help=y (1)语法imp @userid/@password@@tnsname ignore=y fromuser=@fromuser to

2009-03-31 16:40:00 588

原创 Oracle Create TableSpace,User

select * from v$nls_parameters;select * from dba_data_files;--1.创建TABLESPACECREATE TABLESPACE haixin_qaDATAFILE /u01/db/oracle/10gR2/pink/oradata/pink/haixin_qa01.dbfSIZE 100m AUTOEXTEND ONNEXT 50

2009-03-31 16:29:00 1204

原创 Linux新增加一块硬盘

1.fdisk -l命令查看有哪些盘符;2.fdisk /dev/hdc1 -d逐一删除盘符;3.格式化mkfs.ext3 /dev/hdc14.mount /dev/hdc1 /u02 (在根目录下建立u02)5.vi /etc/fstab 自动挂载 /dev/hdc1 /u02 ext3 defa

2009-03-20 15:10:00 714

原创 VB Crash Sample

The following is the code that was causing the application crash.The Public Sub MaintainOcc(ByVal Occ As String, ByVal OccType As String)On Error GoTo ErrHandlerDim frm As frmPickTypeSet frm =

2008-12-18 10:43:00 594

转载【转帖】40种网站设计常用技巧

1. oncontextmenu="window.event.returnValue=false" 将彻底屏蔽鼠标右键 no 可用于Table 2. 取消选取、防止复制 3. onpaste="return false" 不准粘贴 4. oncopy="return false;" oncut=

2008-12-05 09:04:00 540

原创 Cookies 新增删除

(1)清除Cookies Request.Cookies.Remove("UserInfo"); Response.Cookies.Remove("UserInfo"); HttpCookie cookie = new HttpCookie("UserInfo"); cook

2008-12-03 11:11:00 644

转载如何在asp.net中实现返回上一页的功能

如何在asp.net中实现返回上一页的功能2008-07-15 10:11方法一：private void Page_Load(object sender, System.EventArgs e) { ViewState["submittimes"]=Convert.ToInt32(ViewState["sub

2008-12-03 10:04:00 539

原创 Get Dir Path Name

Option ExplicitPrivate Type BROWSEINFO hOwner As Long pidlRoot As Long pszDisplayName As String lpszTitle As String ulFlags As Long lpfn A

2006-09-27 16:22:00 1281

原创 Request 对象

　　可以看到一大堆环境变量，其中还有没有值的，下面摘取几个比较常用的。　　http_user_agent(客户端机器的相关环境)：　　http_accept_language(浏览语言)：　　CONTENT_LENGTH(客户端发出内容的长度)：　　CONTENT_TYPE(内容的数据类型。如“text/html”。同附加信息的查询一起使用，如 HTTP 查询 GET、POST

2006-07-14 11:28:00 915

原创 SourceSafe Auto Backup

Option ExplicitPrivate Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As LongPrivate Const SYNCHRONIZE = &H100

2006-07-07 14:43:00 973

原创 SSDBGrid-Sort By Col

Public Function SortSSDBGridByCol(ByRef pgrdSource As SSDBGrid, ByVal pgrdSelCol As Integer) Dim grdBak As SSDBGrid Dim rsGrid As ADODB.Recordset Dim intI

2006-07-05 08:40:00 1798

原创 VB SourceSafe Auto Backup

Option ExplicitPrivate Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As LongPrivate Const SYNCHRONIZE = &H100

2006-05-06 15:11:00 1041

原创 Oracle DDL DML Collection

1.DBMS_OUTPUTDECLARE strdate VARCHAR2 (20);BEGIN strdate := SYSDATE (); --动态执行DDL语句 DBMS_OUTPUT.put_line (strdate); --PL/SQL printEXCEPTION WHEN OTHERS THEN BEGIN

2006-04-06 20:53:00 1197

原创 Oracle Sequence

Oracle中创建自增型栏位(1)创建Sequence对象; (2)建立一个TriggerCREATE SEQUENCE seq_erictestSTART WITH 1INCREMENT BY 1;CREATE OR REPLACE TRIGGER tr_seq_erictest BEFORE INSERT ON erictest REFERENCING NEW AS NEW

2006-04-06 20:45:00 1047

原创 Oracle Temp Table

oracle 的TEMPORARY TABLE有两种，一种是基Session的，即表中的数据在Session结束前数据都存在。另一种是基于transaction的数据在transaction Commit或Rollback后消失。默认值是基于transaction的。所以你"提交后被告知没有行可以选择"。如果你想数据在Session结束前数据都存在参考下面的例子，或看Oracle的帮助/*****

2006-04-06 20:42:00 3260

原创常用正则表达式

"^/d+$"　　//非负整数（正整数 + 0）"^[0-9]*[1-9][0-9]*$"　　//正整数"^((-/d+)|(0+))$"　　//非正整数（负整数 + 0）"^-[0-9]*[1-9][0-9]*$"　　//负整数"^-?/d+$"　　　　//整数"^/d+(/./d+)?$"　　//非负浮点数（正浮点数 + 0）"^(([0-9]+/.[0-9]*[

2006-01-25 13:41:00 898

原创 Operate SSDBGrid

a. 不管是向Grid中新增数据，还是读取Grid中数据(都涉及到BookMark移动)，在操作之前设定Redraw=True,操作完或遇错误设Redrao=False；b. 往往需要读取Grid上所有数据，这里会有多种方法如Ø 通过grid.MoveFirst，循环中使用grid.MoveNext(最好的方式)；Ø grdFrom.Book

2005-10-27 15:37:00 1350

原创 Write Log in VB

Private Const GENERIC_WRITE = &H40000000Private Const FILE_SHARE_READ = &H1Private Const FILE_SHARE_WRITE = &H2Private Const INVALID_HANDLE_VALUE As Long = -1Private Const FILE_BEGIN = 0Private Decl

2005-10-27 15:25:00 1343