SAm

1.create table create table dbo.app_param( sn int identity(1,1) not null, type nvarchar(50) not null, module nvarchar(50) not null, ckey nvarchar(50) not null, cvalue nvarch...

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl jdbc.username=sam jdbc.password=sam     package com.pipe.dao; import java.sql.Connection; im...

SELECT * FROM (         SELECT  ROW_NUMBER() OVER (ORDER BY a.employee_id) as RowNum,                 a.sn as sn,                 a.policy_no as policyNo,                 a.employee_id as sellerId...

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tablespaceinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) create table tablespaceinfo --创建结果存储表 (nameinfo varchar(50) , ...

PFA...

--JDBC调存储过程 stmt = conn.prepareCall("{call usp_a_insert(['f'])}");   --申明存储过程 alter procedure usp_a_insert @a nvarchar(4), @b bit output as --select * from employee insert into a(a) values(...

聚集索引物理排序，可以为索引设置因子，如果表的删除操作比较多，因子设小一点，只插不删因子就设大一点，数据库数据存在不同的数据分页中，尽量减少分页数据满以后所以分页数据的重新排序，索引还要定期重新执行一下，索引的设置是否合理可以用执行计划去分析。...