03 2014 档案

摘要：'"&A21&"' Excel 中要做字符串连接 “& + 单元格地址 + &”, 如果单纯做测试在某个单元格中测试输出内容: = “ “& A1 &” “, 最外侧的引号代表这个是个字符串. 阅读全文

posted @ 2014-03-14 13:00 DukeCheng 阅读(214) 评论(0) 推荐(1) 编辑

An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON

摘要：If you run into the following error message: An explicit value for the identity column in table ‘’ can only be specified when a column list is used and IDENTITY_INSERT is ON. It can mean two thi... 阅读全文

posted @ 2014-03-11 14:37 DukeCheng 阅读(8290) 评论(0) 推荐(0) 编辑

如何在Vistual Studio Online上删除项目

摘要：http://social.msdn.microsoft.com/Forums/en-US/12ebeee4-e6d1-4b1c-bc01-2887f3b477b1/how-do-i-delete-a-project-created-in-visualstudio-online?forum=TFService 阅读全文

posted @ 2014-03-07 20:41 DukeCheng 阅读(177) 评论(0) 推荐(0) 编辑

T-SQL 删除重复数据SQL

摘要：WITH cte AS ( SELECT roleid,permissionid, row_number() OVER(PARTITION BY roleid,permissionid ORDER BY roleid,permissionid) AS [rn] FROM rolepermissionrecords ) DELETE cte WHERE ... 阅读全文

posted @ 2014-03-07 12:29 DukeCheng 阅读(175) 评论(0) 推荐(0) 编辑

How to Quickly Create a Copy of a Table using Transact-SQL

摘要：The easiest way to create a copy of a table is to use a Transact-SQL command. Use SELECT INTO to extract all the rows from an existing table into the new table. The new table must not exist already. T... 阅读全文

posted @ 2014-03-01 15:59 DukeCheng 阅读(270) 评论(0) 推荐(0) 编辑