Article View: cn.bbs.comp.database
Article #933Re: ��� ��xml����ռ�ı����ĸ�ֵ
From: Galaxy��VOLUNTEERS
Date: Sun, 10 Aug 2008 13:10
Date: Sun, 10 Aug 2008 13:10
44 lines
2478 bytes
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.
[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.146.84][m
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!SJTUShow 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