日月之行

hao 的个人资料日月之行照片日志列表

工具

帮助

日志

2008/7/2

VSTS 强制删除签出锁定项

最近遇到的一个问题，网上找到了解决办法。具体步骤：

1、连接到TFS数据库服务器的tfsversioncontrol库；

2、查tbl_workspace表，找出相应的工作目录，比如 select * from tbl_workspace where workspacename='somebody'

3、利用上一步查到的workspaceid在tbl_pendingchange表中找到尚未签入的项，如： select * from tbl_pendingchange where workspaceid='workspaceid'

4、删除上一步查到的这些项.

5、检查一下tbl_lock表中有没有被锁定的数据。如果有，一并删除。

2008/1/18

忙中出错，教训很深刻

2008新年伊始就郁闷了一下。

项目源代码随便拷来拷去，结果最终版本里丢了个重要的修改。下发以后才发现，要命啊，N个用户，后果很严重！我的程序竟也要发布补丁了。

教训：版本控制很重要！

2007/12/16

书非借不能读也

今年好像很忙，但是好像又没干什么……（用这个作年终总结有点说不过去啊

）

最近看了《作弊的艺术》，似乎是很久以来从头到尾读完的唯一一本书。

另外，“书非借不能读也”，圣人的话就是有道理，尤其是对我这样的懒人。

2007/8/20

暑假结束

两周的假期啊，竟然哪里都没去，可惜了！

9:43 | 添加评论 | 固定链接 | 写入日志

2007/7/31

你们家网站的访问速度怎么样？

http://internetsupervision.com/scripts/urlcheck/check.aspx

德国访问俺们单位的网站好慢啊！

14:00 | 添加评论 | 固定链接 | 写入日志 | 计算机与 Internet

2007/5/30

MS Access, 不好

1、@参数的顺序必须与下面的SQL语句中出现@参数的先后顺序一致，MS SQL则不用。

2、Memo字段在查询时可能会被截断：

Issue	Explanation	Workarounds
Aggregation	When you depress the Σ button, Access adds a Total row to the query design grid. If you leave Group By under your memo field, it must aggregate on the the memo, so it truncates.	Choose First instead of Group By under the memo field. The aggregation is still preformed on other fields from the table, but not on the memo, so Access can return the full memo. The field name changes (e.g. FirstOfMyMemo), so change the name and Control Source of any text boxes on forms/reports.
Uniqueness	Since you asked the query to return only distinct values, Access must compare the memo field against all other records. The comparison causes truncation.	Open the query's Properties Sheet and set Unique Values to No. (Alternatively, remove the DISTINCT key word in SQL View.) You may need to create another query that selects the distinct values without the memo, and then use it as the source for another query that retrieves the memo without de-duplicating.
UNION query	A UNION query combines values from different tables, and de-duplicates them. This means a comparing the memo field, resulting in truncation.	In SQL View, replace UNION with UNION ALL.
Format property	The Format property processes the field, e.g. forcing display in upper case (>) or lower case (<). Access truncates the memo to reduce this processing.	Remove anything from the Format property of: the field in table design (lower pane); the field in query design (properties sheet); the text box on your form/report.