03 2014 档案

Excel 生成SQL
摘要：'"&A21&"' Excel 中要做字符串连接 “& + 单元格地址 + &”, 如果单纯做测试在某个单元格中测试输出内容: = “ “& A1 &” “, 最外侧的引号代表这个是个字符串. 阅读全文
posted @ 2014-03-14 13:00 DukeCheng 阅读(224) 评论(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 阅读(8422) 评论(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 阅读(190) 评论(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 阅读(189) 评论(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 阅读(288) 评论(0) 推荐(0)