Excel: Get cell comments

Categories: Development Notes; Tagged with: ; @ August 23rd, 2012 19:05

1. Alt + F11, in the opening window, click: Insert>Module, paste the folling code:

Function getComment(incell) As String
On Error Resume Next
getComment = incell.Comment.Text
End Function

2. Alt + Q to quit the window

3. use the funciton in cell, like:
=getComment(A1) , will fill the cell with A1’s comments

 

The difference between DELETE and TRUNCATE

Categories: Database; Tagged with: ; @ August 21st, 2012 13:29

DELETE

DML(Data Manipulation Language), is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it. Note that this operation will cause all DELETE triggers on the table to fire.

If you delect one table’s data, the ID will continue in SQL 2005,.

TRUNCATE

DDL(Data Definition Language), TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUCATE is faster and doesn’t use as much undo space as a DELETE.

If you truncate one table, the ID will be reset in SQL 2005.

关于再就业

Categories: 垃圾山 August 19th, 2012 12:02

春天的时候我失业了。

有些东西的存在可以证明另一些东西的价值。 虽然这的确很肤浅,但很多人就是这样。 譬如,学生因为成绩而获得认可,毕业后因为一份好工作又被人刮目相看。

我希望成为这种人, 但很明显,我没有能力通过这种途径证明自己,而且我也不希望因为没有这些东西而否定自己。

但是,我很快就要失业,我必须找份工作糊口。

于是在5月的时候我才开始慌张的面试,马不停蹄的面试,在面试中我深刻认识到一个处女座的挑剔。

我们是个很有爱的集体, 所以在下岗前我们有很多散伙饭,每次散伙饭大家都会有或多或少汇报自己的进步。6月的一天,同事问我,到底是怎么想的? 为什么要在别人接纳自己之前先拒绝掉别人?我觉得从旁人看来我一定是个假胖子,满嘴拒绝别人的表面其实埋藏着一颗饱受蹂躏的心, 但, 其实,事实上, 排除掉运气跟缘分, 没有一颗挑剔的心, 怎能找到一份合适的工作?

终于, 在最后一顿散伙饭的路上,收到一个我不舍得拒绝的offer,这份工作废了很大的力气,英文面试电面2小时,在线考试1小时,现场3小时,外加电面遥控写算法1小时。

很多没出息的男人都把很多事情寄托在三十岁以前。 譬如我一个表哥希望三十岁以前去西藏,但现在的他已经三十有二, 他还没有去过西藏。我跟他一样,把很多人生里的大事都放在三十岁的这一边。下手要趁早, 于是7月的第一个周末我踏上了出国务工的灰机。

在新加坡的面试更多过于上海。 因为在上海的面试,我会有很多filter: 是否世界500强啊, 做产品还是做项目啊,相当的挑剔,所以我每周只会安排两次现场面试,一次电话面试。在这里心态不一样, 毕竟是外出务工, 心态放的很低,薪水合适,不要太多加班就OK。有时候一天会有两三个面试。

7月底,拿到了EP,推掉了上海的Offer,再就业这一关,算是勉强过了。

很多时候,尤其是今年, 我觉得我的人生如游戏,不断的打怪赞经验,升级,换装备。。。

Flex trademark assigned to Apache Software Foundation

Categories: Flex; Tagged with: ; @ August 16th, 2012 18:08

The Apache Flex PPMC would like to inform our community that Adobe Systems Inc. has assigned the Flex trademark to the Apache Software Foundation. This is an important milestone in our progress towards graduating and becoming a full-fledged Apache project.

Adobe will retain a limited license to use Flex for its current Flex products and web-sites so you will still see “Adobe Flex” out there, but Apache is now the official owner of the trademark.

-The Apache Flex PPMC

 

In case you were wondering, the Flex trademark has been assigned to Apache as mentioned here: http://markmail.org/message/vkwfmjkdjzpxrkke.  As the email mentions, this is another step on the road to transitioning Flex to Apache as promised here http://www.adobe.com/devnet/flex/whitepapers/roadmap.html

http://blogs.adobe.com/flex/2012/08/flex-trademark-assigned-to-apache-software-foundation.html

Auto Format SQL Scripts tools: online/desktop app/plugin

Categories: Database; Tagged with: ; @ August 15th, 2012 12:33

Online tool: http://www.dpriver.com/pp/sqlformat.htm

Really easy and fast!

There is a desktop version of this sql formatter, the desktop version has more features, and it’s faster and earier to use. There is also an Add-On version for Visual Studio and an Add-On for SQL Server Management Studio.

 

Newer Posts <-> Older Posts



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.