本月博客排行
-
第1名
龙儿筝 -
第2名
johnsmith9th -
第3名
wy_19921005 - zysnba
- sgqt
- lemonhandsome
- sichunli_030
年度博客排行
-
第1名
宏天软件 -
第2名
青否云后端云 -
第3名
龙儿筝 - gashero
- wallimn
- vipbooks
- benladeng5225
- wy_19921005
- fantaxy025025
- e_e
- zysnba
- ssydxa219
- sam123456gz
- javashop
- arpenker
- tanling8334
- kaizi1992
- xpenxpen
- wiseboyloves
- xiangjie88
- ranbuijj
- ganxueyun
- sichunli_030
- xyuma
- wangchen.ily
- jh108020
- lemonhandsome
- zxq_2017
- jbosscn
- johnsmith9th
- Xeden
- luxurioust
- lzyfn123
- zhanjia
- forestqqqq
- ajinn
- nychen2000
- wjianwei666
- hanbaohong
- daizj
- 喧嚣求静
- silverend
- mwhgJava
- kingwell.leng
- lchb139128
- lich0079
- kristy_yy
- jveqi
- java-007
- sunj
最新文章列表
JPBM,SQLServer 2008设置
hibernate.cfg.xml
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.connection.driver_class"&g ...
几种常见数据库的driverClassName和url
DB2:
driverClassName:com.ibm.db2.jcc.DB2Driver
url:jdbc:db2://localhost:50000/sample
Oracle:
driverClassName:oracle.jdbc.driver.OracleDriver
url:jdbc:oracle:thin:@localhost:152 ...
数据库分页SQL语句
DB2数据库:从数据库表中第I条记录开始检索J条记录SELECT * FROM (SELECT A.*, ROW_NUMBER() OVER() AS NFROM (SELECT * FROM table_name) AS A)WHERE N > I AND N <= J;Oracle数据库:从数据库表中第M条记录开始检索N条记录SELECT * FROM (SELECT ROWNU ...
The steps of configuring SQLServer2005 Database Mirror.doc
1. Executive Summary
The document describes the steps to configure SQL Server 2005
Database Mirror without Witness Server in Certificate Authentication.
Database Mirror is a transparent ...
Excel导入Sqlserver的一些问题!
最近一直整理数据,从Excel导入数据到sqlserver,搞的我焦头烂额。自己总结一下也省得以后忘记了,测试环境SQLSERVER2005,Excel2007.如果在sqlserver中查询97-03的excel是以下语句:
select * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\test.xls;Us ...
sqlserver和oracle中去除某一字段中重复字节,以逗号分隔
sqlserver:
create function reny_str(@str varchar(2000)) returns varchar(20)asbegin declare @t table(a varchar(200)) declare @b table(a varchar(200)) insert @t select substring(@str,n ...
SharePoint 开发实录:6,问题纪要
1. SQLSERVER安装的版本是SQLEXPRESS,使用sharepoint server设置server farm时,数据库的链接内容中,“Database server:”值的格式为:机器名\SQLEXPRESS
往sqlserver中动态添加字段
drop table test
create table test
(
id int primary key identity(1,1),
name varchar(20)
);
alter table test add clm_t1 nvarchar(20) null
alter table test drop column ['+@dateStr+']
sel ...