摘要：
一、查看實例名時可用 1、服务—SQL Server(实例名)，默认实例为(MSSQLSERVER)或在连接企业管理时-查看本地实例2、通過注冊表 HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/InstalledInstance3、用命令sqlcmd/osql sqlcmd -L sqlcmd -Lc osql -L获取可用實例,以下舉一個例子，根據自己情況改DECLARE @Table TABLE ( instanceName sysname NULL)insert @Table EXEC sys.xp_cmdshell 阅读全文
随笔档案-2012年12月
SQL update 语句中使用表别名&&查找占用数据库的进程
2012-12-12 11:13 by 立雪三尺, 263 阅读, 收藏, 编辑
摘要：
SQL update 语句中使用表别名&&查找占用数据库的进程 阅读全文
IIS error: Service Unavailable : HTTP Error 503. The service is unavailable
2012-12-06 16:41 by 立雪三尺, 10764 阅读, 收藏, 编辑
摘要：
Service Unavailable :
HTTP Error 503. The service is unavailable. 阅读全文
IIS发布错误：Could not load file or assembly '....'or one of its dependencies. An attempt was made to load a program with an incorrect f
2012-12-04 11:06 by 立雪三尺, 568 阅读, 收藏, 编辑
摘要：
issue: iis website error:Server Error in '/' Application.Could not load file or assembly '......' or one of its dependencies. An attempt was made to load a program with an incorrect format.reason:1. as the despriction: there is no the file or assembly.2. in the application pool, disa 阅读全文
