04 2016 档案

[SQL] SQL 修复命令
摘要：You should run the repair from the original installation media, using the following command line: setup.exe /ACTION=REPAIR /INDICATEPROGRESS=TRUE Repa 阅读全文
posted @ 2016-04-27 09:04 Areas 阅读(386) 评论(1) 推荐(0) 编辑
[SQL]批量 更改字符集脚本，批量查询约束，批量查询索引
摘要：How to change collation of all database objects in SQL Server. Have you encountered a problem where you wanted to change your database collation to de 阅读全文
posted @ 2016-04-25 10:47 Areas 阅读(282) 评论(0) 推荐(0) 编辑
[SQL] 常用查询脚本
摘要：查询哪些存储过程使用了某个表 select b.name from syscomments a,sysobjects b where a.id=b.id and a.text LIKE '%ftblogkpicontentnew%' 查询某个存储过程被哪些语句使用过 declare @object 阅读全文
posted @ 2016-04-25 10:37 Areas 阅读(667) 评论(0) 推荐(0) 编辑
MarkDownPad2 key
摘要：MarkDownPad2 key :Soar360@live.comGBPduHjWfJU1mZqcPM3BikjYKF6xKhlKIys3i1MU2eJHqWGImDHzWdD6xhMNLGVpbP2M5SN6bnxn2kSE8qHqNY5QaaRxmO3YSMHxlv2EYpjdwLcPwfeT 阅读全文
posted @ 2016-04-25 10:28 Areas 阅读(299) 评论(0) 推荐(0) 编辑