🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #933

Re: ��� �󶨵�xml����ռ�ı����ĸ�ֵ

#933
From: Galaxy��VOLUNTEERS
Date: Sun, 10 Aug 2008 13:10
44 lines
2478 bytes
�ٿ�������Ĵ��룬û����������󵽵���ʲô
����create xml schema collection���������������ָ�ʽ��
DECLARE @MySchemaCollection nvarchar(max)
Set @MySchemaCollection  = N' copy the schema collection here'
CREATE XML SCHEMA COLLECTION MyCollection AS @MySchemaCollection 

����

CREATE XML SCHEMA COLLECTION MyCollection AS N' copy the schema collection 
here'
DECLARE @x xml (MyCollection)

����CREATE����declare,��set������ı��Ǹ�xml schemaô��
����һ��typed xml column�����Ӧ�������£�
--Or create a typed xml column.
CREATE TABLE T (
        i int primary key, 
        x xml (ManuInstructionsSchemaCollection))
GO

����Բο�BOL�ϵ��﷨��
msdn.microsoft.com/en-us/library/ms176009.aspx

 �� �� happier (happier) �Ĵ������ᵽ: ��
: ���������µ�xml schema
: create xml schema collection table_test as
: N'<?xml version="1.0" encoding="UTF-16"?>
: <xsd:schema targetNamespace="http://paperboat.xml.table_test" 
:    xmlns          ="http://paperboat.xml.table_test" 
:    elementFormDefault="qualified" 
:    attributeFormDefault="unqualified"
:    xmlns:xsd="http://www.w3.org/2001/XMLSchema" >
: <xsd:complexType name="StepType" mixed="true" >
:         <xsd:choice  minOccurs="0" maxOccurs="unbounded" > 
: .................������ʡ�ԣ�

--
I thought what I'd do was, I'd pretend I was one of those deaf-mutes
Or should I?

You know what I��d like to be? I mean if I had my goddam choice, I��d just be
the catcher in the rye and all.

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.146.84]
Technical Details
Message-ID: <4bOdlF$bql@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!feeder.erje.net!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,5fe412a6e2cc31b4
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!feeder.erje.net!news.isoc.lu!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��� �󶨵�xml����ռ�ı����ĸ�ֵ
Date: 10 Aug 2008 13:10:07 GMT
Organization: ��ˮ˼Դ
Message-ID: <4bOdlF$bql@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1218373599.A