philzhou

摘要：Recursive queries have been added to T-SQL in SQL Server 2005 in the form of the WITH clause and CTE. The books online documentation is pretty straight forward but a few people have asked me to work up a few useful samples to help get them going. Simply copy/paste these samples into a query window and execute. 阅读全文

摘要：原文ScriptThis article discusses three common problems DBAs are likely to encounter when columns have the identity property, which is defined as an attribute of int, smallint, bigint, decimal, numeric or tinyint columns that will auto-increment their value when data is inserted. These problems are hum 阅读全文

摘要：用于 Web 应用程序项目部署的 Web.config 转换语法.NET Framework 4 Web.config 文件通常包括根据应用程序的运行环境而必须不同的设置。例如，在部署 Web.config 文件时，您可能必须更改数据库连接字符串或禁用调试。对于 Web 应用程序项目，ASP.NET 提供了一些工具，用于自动完成在部署这些项目时更改（转换）Web.config 文件的过程。对于要部署到的每个环境，您将创建一个转换文件，该文件仅指定原始 Web.config 文件和适用于该环境的已部署 Web.config 文件之间的差异。 转换文件是一个 XML 文件，该文件指定在部署 Web 阅读全文