03 2013 档案

替换SQL Server数据库中所有表的所有字段的某些内容
摘要：exec sp_msforeachtable @command1=N' declare @s nvarchar(4000),@tbname sysname select @s=N'''',@tbname=N''?'' select @s=@s+N'',''+quotename(a.name)+N''=replace(''+quotename(a.name)+N'',N''''aa'''&# 阅读全文

posted @ 2013-03-27 19:50 seaven 阅读(215) 评论(0) 推荐(0)

Oracle插入大数据、获取大数据
摘要：插入数据库CLOB tempClob = null;try { Connection conn = getConnection(); PreparedStatement = = conn.prepareStatement("UPDATE PROGRAM_HISTORY SET DETAILS = ? WHERE ID = 12"); tempClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION); tempClob.open(CLOB.MODE_READWRITE); Writer tempClobWri 阅读全文

posted @ 2013-03-21 09:26 seaven 阅读(900) 评论(0) 推荐(0)

导航