- 博客(35)
- 资源 (1)
- 收藏
- 关注
RSS订阅转载 Mac系统mds、mds_stores、mdworker疯狂工作的问题
这几个进程都是为了Spotlight索引而疯狂的，解决方案：sudo mdutil -a -i off打开sudo mdutil -a -i on
2016-06-24 21:12:08
22413
原创 tsql default values, check current isolation level, check db object last update time
1) ALTER TABLE teseTable ADD column1 char(1) default 'S' with valueswith values will set values for for new column for existing rows. 2) check current isolation levelSELECT CASE
2016-06-14 16:19:27
587
原创 check if filed exists in all tables in current DB
SELECTt.name AS table_name,SCHEMA_NAME(t.schema_id)AS schema_name,c.nameAS column_name , types.name, c.max_lengthFROMsys.tables AS tINNERJOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_IDinn
2016-06-13 17:49:37
367
原创 spring declarative transaction management
读作:当执行到 com.a.b.c.refresh 的时候，与之关联 [由aop:advisor 关联] 的advise里面配置的refresh方法被事务进行管理，并对任何异常进行事务回滚。
2016-06-13 14:56:06
361
原创 Vocabulary analysis
import java.io.BufferedReader;import java.io.File;import java.io.FileReader;import java.io.FileWriter;import java.util.ArrayList;import java.util.Collections;import java.util.Comparator;
2016-06-13 14:33:30
330
原创 no title
alter trigger trgStu on stufor deleteas declare @sqlCmd nvarchar(1000),@tableName varchar(128),@id varchar,@pkColumnName varchar(128)beginselect @id=2 --id from deletedset @tableNa
2011-06-05 12:41:00
347
原创 cursor
<br /> declare @a varchar(10),@b varchar(10),@c varchar(10),@d varchar(10)<br /> DECLARE del_cursor CURSOR FOR <br /> SELECT * FROM #t2 <br /> OPEN del_cursor <br /> FETCH NEXT FROM del_cursor into @a,@b,@c,@d<br /> WHILE @@FETCH_STA
2011-06-02 23:42:00
327
原创 cursor in sql
<br />http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/40f5635c-9034-4e9b-8fd5-c02cec44ce86
2011-06-02 18:08:00
282
原创 get inserted values into...
<br />set ANSI_NULLS ON<br />set QUOTED_IDENTIFIER ON<br />go<br /><br />alter trigger [tri3] on [dbo].[stu]<br />after insert --,update,delete<br />as<br />declare @intCountColumn int,<br /> @intColumn int, <br /> <br /> @actionId varchar(36),<br
2011-06-02 01:32:00
365
原创 quotation2 dynamic
Dynamically Constructed Queries<br />This section examines some ways in which you can construct queries dynamically, including:<br />Executing a string statement<br />Querying by form<br />Using parameterized queriesExecuting a String<br />Transact-SQL con
2011-05-25 00:41:00
719
原创 quotation
What Triggers a Trigger?<br />A DML trigger is executed once for each modification statement (Insert, Update, or Delete). An After trigger is fired after the modification statement finishes successfully. If a statement fails for another reason (for example
2011-05-25 00:39:00
477
原创 trigger
<br />alter trigger tri3 on stu3<br />after insert,update,delete<br />as<br />declare @intCountColumn int,<br /> @intColumn int,<br /> @tmp varchar(16)<br />--inserted<br /> select @intCountColumn=count(ordinal_position)<br /> from Information_Sche
2011-05-25 00:37:00
257
转载 swfobject
<br />SWFObject”是利用Javascript 插入flash，好处多多，代码简洁，不会出现IE6下的“单击此处以激活控件”的提示，并且能通过W3C验证。不同于传统的“object”插入flash的方法。<br />SWFObject在新的2.x版本中，其最简单的调用竟只需一句话，并且不需要等待页面加载完成，这意味着你可以将这句话写在页面的任何地方。比以前的版本，要简便多了。下面来看几个简单常用的调用方法：<br />1、最简单，最基本，只要想插入flash都能用到的经典一句话。<br /><d
2011-01-20 17:17:00
387
转载 iframe 自适应
http://ued.koubei.com/?p=243<br /><br /><iframe id="frame_content" src="iframe_b.html" scrolling="no" frameborder="0" onload="this.height=100"></iframe><br /><br /><script type="text/javascript"><br /><br />function reinitIframe(){<br /><br />var i
2010-12-10 08:47:00
333
转载 Browser Engines
Trident:<br />Internet Explorer、Maxthon遨游、世界之窗、腾讯TT、Netcapter、Avant.<br />(Windows only and not opensource)<br /><br />Gecko:Firefox、Netscape6至9。<br />(cross platform, open source)<br /><br />WebKit:<br />Safari,Chrome。<br />(opensource, mainly
2010-11-26 09:35:00
267
转载 5件事系列
<br />http://www.ibm.com/developerworks/cn/views/java/libraryview.jsp?search_by=%E6%82%A8%E4%B8%8D%E7%9F%A5%E9%81%93%E7%9A%84+5+%E4%BB%B6%E4%BA%8B<br /> <br />http://www.ibm.com/developerworks/cn/java/j-5things12/index.html<br />很多年前，当我还是高中生的时候，我曾考虑以小说作家作为
2010-11-18 20:03:00
349
原创 apache 2.2 --> php 5
apache 2.2 --> php 5 1)install apache2.22)updage httpd.conf a: DocumentRoot "D:/.../web" b: c: LoadModule php5_module "C:/php5/php5apache2_2.dll" d: PHPIniDir "C:/php5" e: AddType application/x-httpd-php .php #in part
2010-11-15 16:03:00
235
原创 CENTOS 5 virtualbox additions installation and ...
<br />yum install gcc<br />yum install kernel sources<br />yum install kernel-devel<br /><br />sh VBoxLinuxAdditions-x86.run<br /> <br /> <br />http://wiki.centos.org/AdditionalResources/Repositories/RPMForge
2010-11-11 22:48:00
264
原创 php->java
<br />HashMap:<br /> <br /> $alarms = $report->alarms;<br /> foreach ($alarms as $item){<br /> $colors->put($item->name,$item->colorString);<br /> }<br /> <br />Array:<br /> <br /> $histograms=array();<br />
2010-10-29 11:26:00
276
原创 AS3 TIMER
<br /> public function Robot() {<br /> randomFrameTimer = new Timer(200);<br /> randomFrameTimer.addEventListener(TimerEvent.TIMER,onTimer);<br /> randomFrameTimer.start();<br /> }<br /> <br /> private function o
2010-10-27 10:03:00
330
原创 move tree node up
<br />public class aaa extends JFrame {<br /><br /> private String filename = "my_xml_file.xml";<br /> private JTree myTree;<br /><br /> public aaa() {<br /> myTree = new JTree();<br /> setBounds(10,10,310,310);<br />
2010-10-26 17:28:00
334
原创 JDBC DB CONN STRING
<br />SQL SERVER 2005:<br /> private String dbDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";<br /> private String url = "jdbc:sqlserver://localhost:1433;databaseName=db_shopping";<br /> <br />SQL SERVER 2000:<br /> private String dbDri
2010-10-14 22:09:00
391
原创 SMTP & IMPLEMENTATION
R: 220 BBN-UNIX.ARPA Simple Mail Transfer Service Ready<br /> S: HELO USC-ISIF.ARPA<br /> R: 250 BBN-UNIX.ARPA<br /><br /> S: MAIL FROM:<[email protected]><br /> R: 250 OK<br /><br /> S: RCPT TO:<Jones@BB
2010-10-14 14:49:00
331
原创 mail to
<br /><html><br /><body><br /><form action="" id="mailer"><br /><input type="hidden" id="deviceMonitor_mail_cc" name="cc"/><br /><input type="hidden" id="deviceMonitor_mail_bcc" name="bcc"/><br /><input type="hidden" id="deviceMonitor_mail_subjec
2010-10-11 13:58:00
6113
原创 get web url content length
public class ClientWithResponseHandler { public static void main(String[] args) { test("http://www.google.com"); } public static String test(String url) { String result = ""; try { URL httpurl = new UR
2010-10-11 10:13:00
375
原创 JAVA Properties R/W
/* * To change this template, choose Tools | Templates * and open the template in the editor. */package bbspad.prop;import java.io.FileInputStream;import java.io.FileOutputStream;import java.util.Properties;public class Configuration {
2010-10-08 22:19:00
259
原创 js:reg validation
var b=$('begintime').value.match(/^(/d{2})-(/d{2})-(/d{4}) (/d{2}):(/d{2})$/); var e=$('endtime').value.match(/^(/d{2})-(/d{2})-(/d{4}) (/d{2}):(/d{2})$/); var bd=new Date(b[3],b[1]-1,b[2],b[4],b[5],0);var ed=new Date(e[3],e[1]-1,e[2],e[4],e[5],0);
2010-09-28 12:08:00
343
原创 VBA : auto chart area
Sub Auto_Open() Dim sheetCount As Integer Dim BaseRowNum As Integer Dim AvailableRowNum As Integer Dim i As Integer sheetCount = Application.Sheets.Count BaseRowNum = 14 For i = 1 To sheetCount AvailableRowNum =A
2010-09-10 17:05:00
446
转载 VBA语句集
VBA语句集(第1辑)定制模块行为(1) Option Explicit '强制对模块内所有变量进行声明Option Private Module '标记模块为私有，仅对同一工程中其它模块有用，在宏对话框中不显示 Option Compare Text '字符串不区分大小写 Option Base 1 '指定数组的第一个下标为1(2) On Error Resume Next '忽略错误继续执行VBA代码,避免出现错误消息(3) On Error GoTo ErrorHa
2010-09-10 11:00:00
304
原创 JXL : write images and... into excel
WorkbookSettings setting = new WorkbookSettings(); WritableWorkbook workbook = Workbook.createWorkbook(new File( "C:/ABC.XLS"), setting); WritableSheet ws = workbook.createSheet("Trending Report", 0); //styles WritableCe
2010-09-09 13:19:00
368
原创 excel OFFSET
OFFSET(reference,rows,cols,height,width)Reference 作为偏移量参照系的引用区域。Reference 必须为对单元格或相连单元格区域的引用；否则，函数 OFFSET 返回错误值 #VALUE!。Rows 相对于偏移量参照系的左上角单元格，上（下）偏移的行数。如果使用 5 作为参数 Rows，则说明目标引用区域的左上角单元格比 reference 低 5 行。行数可为正数（代表在起始引用的下方）或负数（代表在起始引用的上方）。Cols
2010-09-08 09:43:00
742
转载 transformMultipleSheetsList
public HSSFWorkbook transformMultipleSheetsList(InputStream is, List objects, List newSheetNames, String beanName, Map beanParams, int startSheetNum) throws ParsePropertyException { 该方法里面的参数说明如下： 1）is：即Template文件的一个输入流 2）newShe
2010-09-07 17:14:00
5096
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人