摘要：数据规范化！！！ 以前看到有网友在提问问题给表例的时候，可以明显看出这个关系不符合最基本的INF，2NF， 3NF！下面我就简要介绍一下关系的规范化中的第一范式，第二范式和第三范式！这是关系规范化中最基本的！ 第一范式：每个分量必须是不可再分的数据项！如你可以把姓和名分... 阅读全文

摘要：Microsoft SQL Server 2005 and Vs.net 2005 April 2005 Version. 微软三月份才出来一个SQL Server 2005和Vs.net 2005的beta版，现在在推出了一个新的April 10Beta.今天下载了一下，用一下。 先看了一下.net Framework version: v2.0 50110 现在的这个是： v 2.0.5021... 阅读全文

摘要：XML IN 20 MINUTES! http://www.sqlservercentral.com/columnists/lplatt/20010422115709_1.asp This article will quickly dive head first right into XML. I will take an everyday object and attempt to de... 阅读全文

摘要：the following is the SP demo: usingSystem; usingSystem.Data; usingSystem.Data.Sql; usingSystem.Data.SqlServer; usingSystem.Data.SqlTypes; publicpartialclassStoredProcedures { [SqlPr... 阅读全文

摘要：XQuery is a language for XML data.XQuery syntax includes and extends XPaths 2.0 expressions and makes it possible to perform complex queries against on XML data source. An XQuery path is based on the ... 阅读全文

摘要：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... 阅读全文

摘要：Injection Attach We ALL know (I hope) that certain formulations OF dynamic SQL expose the DBMS TO special security risks called "injection attacks". Now we will discuss it and give you a way to pr... 阅读全文

摘要：Main Monitor counts about SQLServer 2000 The following describle the main counts about SQL Server.include: TOC \o "1-1" \n \h \z \u 1.Monitoring Memory and Paging File Use 2.Processor 3.Mo... 阅读全文