FIX: ????? ??? ??? ????? ??????? ???? ????? ??? ??? XML FOR ????????? ?? SQL Server 2005: ? ??? ?????? XML ??? ?

?????? ????????? ?????? ?????????
???? ???????: 933808 - ??? ???????? ???? ????? ????? ??? ???????.
???: # 50000918 (??????? ?????? SQL)
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

??? ????? ??????? ???? ????? ??? ??? XML FOR ????????? ?? SQL Server 2005 ????? ????? ????? ???????:
msg 6611 ? ????? 16 ???? 1? ??? 2
??? ?????? XML ????.
???? ??? ??????? ??? ????? ???????? ?????????:
  • ?????? ??? XML FOR ????? TYPE.
  • ????? ????? ??????? XQuery ????????? ?? ??? ?????? XML ???? ?? ??????? ?????? ?????????.
  • ?? ????????? XQuery ???? QNames ?? ???? ???? FOR XML.

????

??????? ??????? ????????

??? ??? ??????? ??? ?????? ??? ???? ??????? ???????? ?? SQL Server 2005 ?????? ????? ?????? SP2 (???? 3161). ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???????? ??????? ?????? (???? 3161) ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935356????? ???? ??????? ???????? (???? 3161) SQL Server 2005 ?????? ????? ?????? SP2

??????? ??????? ??????

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

????????? ????????

  • SQL Server 2005 Service Pack 2
    ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

????? ????? ?????????

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????.

??????? ???????

?? ??? ???? ????? ?????.

??????? ??? ??????? ??????

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3155.0296,30413 ???? ????14: 12x 86
Msmdlocal.dll9.0.3155.015,930,22413 ???? ????14: 12x 86
Mssqlsystemresource.ldf??? ???? ???????524,28813 ???? ????11: 11??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,56813 ???? ????11: 11??? ???? ???????
Rdistcom.dll2005.90.3155.0644,46413 ???? ????14: 12x 86
Sqlaccess.dll2005.90.3155.0350,57613 ???? ????14: 12x 86
Sqlservr.exe2005.90.3155.029,192,56013 ???? ????14: 12x 86
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3155.0296,30413 ???? ????14: 12x 86
Msmdlocal.dll9.0.3155.015,930,22413 ???? ????14: 12x 86
Mssqlsystemresource.ldf??? ???? ???????524,28813 ???? ????11: 11??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,56813 ???? ????11: 11??? ???? ???????
Rdistcom.dll2005.90.3155.0828,27213 ???? ??????: ??x 64
Sqlaccess.dll2005.90.3155.0357,74413 ???? ??????: ??x 86
Sqlservr.exe2005.90.3155.038,577,00813 ???? ??????: ??x 64
????? ????? SQL Server 2005 Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3155.0296,30413 ???? ????14: 12x 86
Msmdlocal.dll9.0.3155.049,815,92013 ???? ????20: 35IA-64
Mssqlsystemresource.ldf??? ???? ???????524,28813 ???? ????11: 11??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,56813 ???? ????11: 11??? ???? ???????
Rdistcom.dll2005.90.3155.01,885,04013 ???? ????20: 35IA-64
Sqlaccess.dll2005.90.3155.0352,11213 ???? ????20: 35x 86
Sqlservr.exe2005.90.3155.072,547,18413 ???? ????20: 35IA-64

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server

????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

????? ????? ????? ???????

  1. ??? Studio ????? ???? SQL ?? ?? ?????? ??????? ????.
  2. Run the following statements:
    CREATE TABLE [dbo].[TABLE0](
    	[COL0] [int] NULL,
    	[COL1] [varchar](50) NULL,
    	[COL2] [varchar](50) NULL,
    	[COL3] [varchar](50) NULL,
    	[COL4] [varchar](50) NULL,
    	[COL5] [varchar](50) NULL,
    	[COL6] [varchar](50) NULL,
    	[COL7] [varchar](50) NULL,
    	[COL8] [varchar](50) NULL
    ) ON [PRIMARY]
    
    CREATE TABLE [dbo].[TABLE1](
    	[COL0] [int] NULL,
    	[COL1] [int] NULL,
    	[COL2] [varchar](50) NULL,
    	[COL3] [varchar](50) NULL,
    	[COL4] [varchar](50) NULL,
    	[COL5] [varchar](50) NULL,
    	[COL6] [varchar](50) NULL,
    	[COL7] [varchar](50) NULL,
    	[COL8] [varchar](50) NULL
    ) ON [PRIMARY]
    GO
    
    -- Populating tables
    
    DECLARE @X INT, @Y INT
    SET @X=0
    WHILE @X < 20
      BEGIN
    	INSERT TABLE0 VALUES(@X,'DATAFORCOLUMN1','DATAFORCOLUMN2','DATAFORCOLUMN3','DATAFORCOLUMN4','DATAFORCOLUMN5','DATAFORCOLUMN6','DATAFORCOLUMN7','DATAFORCOLUMN8')
    	SET @Y=0
    	WHILE @Y < 20
    	  BEGIN
    		INSERT TABLE1 VALUES(@X,@Y,'DATAFORCOLUMN2','DATAFORCOLUMN3','DATAFORCOLUMN4','DATAFORCOLUMN5','DATAFORCOLUMN6','DATAFORCOLUMN7','DATAFORCOLUMN8')
    		SET @Y=@Y+1
    	  END
        SET @X=@X+1
      END
    
    -- 
    
    SELECT
    (
         SELECT TABLE0.COL0,
    		    TABLE0.COL1,
    			TABLE0.COL2,
                TABLE0.COL3,
                TABLE0.COL4,
                TABLE0.COL5,
                TABLE0.COL6,
                TABLE0.COL7,
                TABLE0.COL8,
                (           
                      SELECT 
                            TABLE1.COL0,
                            TABLE1.COL1,
                            TABLE1.COL2,
                            TABLE1.COL3,
                            TABLE1.COL4,
                            TABLE1.COL5,
                            TABLE1.COL6,
                            TABLE1.COL7,
                            TABLE1.COL8
                      FROM TABLE1
                      WHERE TABLE0.COL0=TABLE1.COL0
                              FOR XML PATH('RECORDS'), ROOT('TABLE1'),TYPE   
                ) 
          FROM
                TABLE0 FOR XML PATH('RECORDS'), ROOT('TABLE0'),TYPE         
    ).query
    ('
          for $record in /TABLE0/RECORDS/TABLE1/RECORDS
          return
                <OUTPUTXML>
                      {$record/../../COL0}
                      {$record/COL1}
                </OUTPUTXML>
    ')
    

???????

???? ???????: 933808 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.4
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbautohotfix kbpubtypekc kbqfe kbhotfixserver kbfix kbsql2005engine kbexpertiseadvanced KB933808 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????933808

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com