- 博客(21)
- 收藏
- 关注
RSS订阅原创 一个TABLESPACE对应多个数据文件
DROP user EHRAUCHAN CASCADE; --注意 ：删除用户包括所有对象已经用户拥有的表中包括的数据。select name from v$datafile;DROP TABLESPACE "EHRAUCHANNEW" including contents and datafilescreate tablespace "EHRAUCHANNEW" datafile
2012-02-03 09:56:36
798
原创 C# DownloadFile
public void DownloadFile(string dowloadFilePath) { Response.Clear(); Response.Buffer = true; Response.Expires = 0; System.IO.FileStream _streamReader = System.IO.Fi
2012-02-02 09:32:48
1108
原创 SQL 文件内容存储表 创建索引
exec sp_fulltext_database 'enable'exec sp_fulltext_catalog 'CATE_DOC_FILES', 'create'exec sp_fulltext_table 'CM_BSS_DOCFILES', 'create', 'CATE_DOC_FILES', 'PK_C'exec sp_fulltext_column 'CM_BSS
2012-02-02 09:16:30
290
转载 C# 生成EAN13 BarCode
VS.NET2005using System;using System.Collections;using System.ComponentModel;using System.Drawing;using System.Data;namespace WebServiceExcelHelper{ public class EAN13 { priv
2012-02-01 13:12:59
2949
原创 C# 操作Excel
using System;using System.Data.OleDb;using System.Data.SqlClient;using System.Data;using System.Reflection;using OfficeExcel = Microsoft.Office.Interop.Excel;using System.IO;using System.Collec
2012-02-01 11:42:49
545
原创 SQL Procedure示例程序04
CREATE procedure [dbo].[eosp_CreateEPOS_CARD](@cC_NO VarChar(30),@cC_DATE DateTime,@sTATUS Char(1),@lAST_PAY_TIME DateTime,@oRDER_NUMBER VarChar(12),@pAN VarChar(19),@eXPIREDDATE Char(10),@cV
2012-02-01 11:11:54
481
原创 SQL Procedure示例程序03
ALTER PROCEDURE [dbo].[AssignAreaRightToUsers] ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @CustomerID
2012-02-01 11:06:45
260
原创 ASP.NET 弹出窗体选择控件
" type="text/css" rel="stylesheet"> <asp:Button ID="btnClick" runat="server" onclick="btnClick_Click" style="display:none" Text="Button" /><asp:Button ID="btnClearClick"
2012-02-01 11:03:46
542
原创 SQL Procedure示例程序02
ALTER PROCEDURE [dbo].[SP_HRXZ_GetRptSalaryReportList] ( @PACKAGE_ID VARCHAR(50), @REGION_CODE NVARCHAR(100), @AREA_NAME NVARCHAR(100), @OUTLET_NAM
2012-02-01 10:57:15
545
原创 SQL Function示例程序01
/****** Object: UserDefinedFunction [dbo].[GetActualBaseSalary] Script Date: 02/01/2012 10:52:12 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--获取员工实际底薪--@oid 促销员号--@caculate_end_d
2012-02-01 10:54:11
358
原创 SQL Procedure示例程序01
/****** Object: StoredProcedure [dbo].[SP_HRXZ_CACULATE_ITEMS] Script Date: 02/01/2012 10:50:37 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[SP_HRXZ_CACU
2012-02-01 10:48:55
504
转载 将表中数据转换成Insert语句
/****** Object: StoredProcedure [dbo].[spGenInsertSQL] Script Date: 02/01/2012 10:48:38 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[spGenInsertSQL] @tablen
2012-02-01 10:47:05
510
原创 Oracle Procedure示例05
CREATE OR REPLACE PACKAGE XXSC_UTIL_PKG IS /*--------------------------------------------------------- Current Version : 1.00 Copyright (C) 2006 BenQ Corporation. All rights reserve
2012-02-01 10:03:39
299
原创 Oracle Function 示例01
CREATE OR REPLACE PACKAGE XXDM_UTIL_PKG is/*--------------------------------------------------------- Current Version : 1.00 Copyright (C) 2006 BenQ Corporation. All rights reserved. Create By
2012-02-01 09:41:11
377
原创 Oracle Trigger示例01
CREATE OR REPLACE TRIGGER DEMANTRA.XXDM_TRIG_INSERT_PORTAL_TASK AFTER INSERT ON PORTAL_TASKREFERENCING NEW AS NEW OLD AS OLD FOR EACH ROWdeclare v_query_id NUMBER :=-1;begin BEGI
2012-02-01 09:39:21
350
原创 Oracle Procedure示例04
CREATE OR REPLACE PACKAGE XXDM_SOP_OUTBOUND_PKG IS /*--------------------------------------------------------- Current Version : 1.00 Copyright (C) 2009 BenQ Corporation. All rights
2012-02-01 09:37:52
305
原创 Oracle Procedure示例03
CREATE OR REPLACE PACKAGE XXDM_SOP_OUTBOUND_PKG IS /*--------------------------------------------------------- Current Version : 1.00 Copyright (C) 2009 BenQ Corporation. All rights
2012-02-01 09:35:40
484
原创 Oracle Procedure示例02
CREATE OR REPLACE PACKAGE XXDM_FORECAST_TO_ASCP_PKG IS /*--------------------------------------------------------- Current Version : 1.00 Copyright (C) 2006 BenQ Corporation. All ri
2012-02-01 09:29:14
782
原创 Oracle Procedure示例01
CREATE OR REPLACE PACKAGE XXASCP_ITEM_SOURCING_RULE_PKG IS /*--------------------------------------------------------- Current Version : 1.00 Copyright (C) 2009 BenQ Corporation. Al
2012-02-01 09:23:33
335
原创 SQL 存储过程示例02
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--获取销售订单编号ALTER PROCEDURE [dbo].[DCM_GenerateSaleOrderNo] ASDECLARE @ErrorCode nvarchar(10)DECLARE @ErrorMsg nvarchar(255)DECLARE @OrderN
2012-02-01 09:14:39
208
原创 SQL 存储过程示例01
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO----将DCM中的系统用户资料同步到WebOrder用户表ALTER PROCEDURE [dbo].[SP_WO_SYNC_SYS_USERS] ( @IsFirst int, --是否是第一次导入 @WebOrderDBName nvarchar(50) --
2012-02-01 09:12:53
326
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人