董晓涛(David Dong)

摘要： there are typed XML and Untyped XML that SQL Server 2005 Support. to use Untyped XML,you must have formet XML.and you can implict and emplict varchar to XML. to use typed XML,you must register XML ... 阅读全文

摘要： In SQL Server 2000, you can use a varchar, nvarchar, text, or ntext variable to generate a document handle using the sp_xml_preparedocument stored procedure. In SQL Server 2005, you can also use an x... 阅读全文

摘要： In SQL Server 2000, RAW mode FOR XML queries can return only attribute-centric XML. In SQL Server 2005, you can use the ELEMENTS directive with RAW mode queries to return element-centric XML. The foll... 阅读全文

摘要： Work with XML Data Type in SQL Server 2005 from ADO.NET 2.0 One of the excellent features of the next release of SQL Server, known as SQL Server 2005, is its deep XML integration with the SQL Se... 阅读全文

摘要： 群集安装 一.安装概述 在安装过程中，安装某些节点时将关闭其他节点。这个步骤有助于保证附加到共享总线的磁盘上的数据不会丢失或遭到破坏。当多个节点同时尝试写入一个未受到群集软件保护的磁盘时，可能会出现数据丢失或遭到破坏的情况。另外与 Microsoft Windows 2000 系统不同，Windows 2003 Server 中新磁盘的默认装载方式有所变化。在 Wind... 阅读全文

摘要： Why use Store procedure 第一:提高性能 第二:减少网络流量 第三:减少注入式攻击 3.1易受注入式攻击的代码: 3.2优化过的代码 3.3使用存储过程来减少注入攻击 第一:提高性能 当存储过程被创建,它要经过以下几步,第一步,它所包含的T-SQL语句将被分析和解析,并被存储.当第一次被执行时,它将被调出并被优化.SQLServer会根... 阅读全文

摘要： ADO Multidimensional Now that you've taken a whirlwind tour of MDX, let's shift gears and look at another enabling technology: ADOMD. ADOMD allows you to query both the cube schema and data from a si... 阅读全文

摘要： Microsoft SQL Server 2005 的 XML 最佳实施策略 日期：2004年7月30日 作者： Shankar Pal、Vishesh Parikh、Vasili Zolotov、Leo Giakoumakis、Michael Rys Microsoft C... 阅读全文

摘要： This is avery short post containing a useful code snippet for writing to a SQL Server Integration Services (SSIS) variable from within a script task. Imports Microsoft.SqlServer.Dts.Runtime Public... 阅读全文

摘要： Counting Rows in SQL Server Integration Services I am often asked if there is a way to capture row counts in SSIS. For example, a user may want to know how many rows passed along certain outputs o... 阅读全文