- 博客(26)
- 收藏
- 关注
原创 查找不可见字符的正则表达式
[\x0-\x1f\x7f]000 00 000 ^@ NUL001 01 001 ^A SOH002 02 002 ^B STX003 03 003 ^C ETX004 04 004 ^D EOT005 05 005 ^E ENQ006 06 006 ^F ACK007 07 007 ^G BEL008 08 010 ^H BS009 09
2015-09-11 10:32:16
11495
原创 java实例化对象的方法
1.new关键字A a1=new A()----------------------------------------------2.Cloneable类的clone方法A a2=A.copy()//implements Cloneable: A copy(){return (A)this.clone()}-----------------------------
2015-09-08 11:22:19
797
转载 Linux / Unix Command: awk命令
Linux / Unix Command: awk Command LibraryNAMEgawk - pattern scanning and processing language SYNOPSISgawk [ POSIX or GNU style options ] -f program-file [ -- ] fil
2015-09-07 09:08:08
1850
转载 Linux / Unix Command: grep命令
Linux / Unix Command: grepCommand LibraryNAMEgrep, egrep, fgrep - print lines matching a patternEXAMPLESSYNOPSISgrep [options] PATTERN [FILE...]grep [options] [
2015-09-07 09:06:35
687
转载 Linux / Unix Command: sed命令
Linux / Unix Command: sedCommand Librarysed - manual page for sed version 4.0.3NAMEEXAMPLESSYNOPSISsed [OPTION]... {script-only-if-no-other-script} [input-file]..
2015-09-07 09:05:22
750
转载 Linux / Unix Command: find命令
Linux / Unix Command: findCommand LibraryNAMEfind - search for files in a directory hierarchyEXAMPLESSEE ALSOlocate(1L), locatedb(5L), updatedb(1L), xargs(1L)
2015-09-07 09:01:13
976
原创 sp_MSforeachtable的用法,对某数据库的所有表进行操作
EXEC sp_MSforeachtable @command1="DBCC UPDATEUSAGE('tempdb','?') WITH count_rows",@command2="sp_spaceused '?'"sp_MSforeachdb有类似的用法
2015-08-19 16:39:13
1180
原创 视图不能更新的检查,制约失效的检查
select * from sysobjects where id in( SELECT parent_obj FROM sysobjects WHERE xtype = 'C' AND status &0x800 = 0x800)
2015-08-19 16:38:00
361
原创 有ID列的表
select object_name(id) tablename,name IDFieldfrom syscolumnswhere status=0x80
2015-08-19 16:37:06
294
原创 列出有非簇集索引的表
select o.name as TableName ,i.name as IndexNamefrom sysindexes iinner join sysobjects o on i.id = o.idwhere type = 'u' and indid>1and i.name not like '_WA_Sys_%'order by o.name
2015-08-19 16:35:13
341
原创 javascript使用正则表达式格式化货币,金额
var val='212312.235423'var rex = /\d{1,3}(?=(\d{3})+$)/g;val.replace(/^(-?)(\d+)((\.\d+)?)$/, function (s, s1, s2, s3) { return '$' + s1 + s2.replace(rex, '$&,') + s3; })//"$
2015-08-19 14:42:32
5032
原创 sp_spaceused 或者sysindexes 的rowcnt不准确的解决办法
DBCC UPDATEUSAGE('dbname','tablename') WITH count_rows
2015-08-18 16:37:37
586
原创 扩展存储过程 xp_smtp_sendmail的安装
文件: xpsmtp80.dll存放路径: C:\Program Files\Microsoft SQL Server\80\Tools\Binn注册存储过程: EXEC master.dbo.sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'
2015-08-18 16:35:32
370
原创 bootstrap,select
http://silviomoreto.github.io/bootstrap-select/Usage:--Create your with the .selectpicker class.--Enable Bootstrap-Select via JavaScript:$('.selectpicker').selectpicker();--$('.selectpick
2015-08-18 16:33:35
596
原创 sublime text格式化代码
设定:preferences menu-->Key Binding - UserDefault (Windows).sublime-keymap添加一行 { "keys": ["alt+shift+f"], "command": "reindent" , "args": { "single_line": false } } 使用:指定syntax(例如:javascri
2015-08-18 08:55:38
395
原创 bootstrap link
http://www.revillweb.com/tutorials/bootstrap-tutorial/http://getbootstrap.com/components/:Over a dozen reusable components built to provide iconography, dropdowns, input groups, navigati
2015-08-17 11:23:37
586
原创 ascii码
000 00 000 ^@ NUL001 01 001 ^A SOH002 02 002 ^B STX003 03 003 ^C ETX004 04 004 ^D EOT005 05 005 ^E ENQ006 06 006 ^F ACK007 07 007 ^G BEL008 08 010 ^H BS009 09 011 ^I HT010 0a 012 ^
2015-08-15 09:00:51
318
原创 BULK INSERT的使用,FIRSTROW的赋值
BULK INSERT tempdb.dbo.TMP_TEST FROM 'C:\DATA\TMP_TEST.csv' WITH (KEEPIDENTITY, FIELDTERMINATOR = '\t',ROWTERMINATOR = '\n',BATCHSIZE =1000 )BATCHSIZE选项的必要性:针对大文件,大数据提交的情况非常必要FIRST
2015-08-14 09:08:49
691
原创 truncate table 之后id列的处理,重置ID列
select IDENT_CURRENT('TM_TEST')--20899486truncate table TM_TESTDBCC CHECKIDENT (TM_TEST, RESEED, 20899486)
2015-08-13 11:56:50
751
原创 jquery Deferred 数组
$.when.apply($, arrayDeferred).done(function () { //source code to run when done //...});
2015-08-12 15:35:58
409
原创 javascript 等待 settimeout
var wait = function () { if (arr.length > 0) {//等待的条件 window.setTimeout(wait, 50) } else { arr= []; }}wait();
2015-08-11 09:59:00
471
原创 javascript自定义 error事件
(function () { var pError = console.error; console.error = function (msg) { pError.apply(console, arguments); alert(msg); };})();window.onerror = function (errorMessage, u
2015-08-10 14:08:46
515
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人