Article View: cn.bbs.comp.database
Article #869Re: ����xml schema����֤������
From: Galaxy��VOLUNTEERS
Date: Wed, 08 Oct 2008 02:39
Date: Wed, 08 Oct 2008 02:39
35 lines
2817 bytes
2817 bytes
sql server������Զ����飿 �ο��������ݣ� Use typed XML data type under the following conditions: You have schemas for your XML data and you want the server to validate your XML data according on the XML schemas. You want to take advantage of storage and query optimizations based on type information. You want to take better advantage of type information during compilation of your queries such as static type errors. from link: http://msdn.microsoft.com/en-us/library/ms345115.aspx �� �� happier (happier) �Ĵ������� ��: �� : ��Sql Server2005�Լ�Oracle 9���涼�ж���xml schema,Ȼ������xml����ǻ��ڴ� : schema��ʽ�ģ������ʵ�������: : 1:)�����������Ҳ�?�ǻ��ڴ�schmea,�����������֤data����Ч��? : Ʃ��˵<name>paperboat</name> ��element name�µ�������xsd:string�͵ģ��������ǹ� : ��string��maxLength ��10�� ������һ��<nam>paperboatpaperboat</name>������� : ����ġ� : ���ڣ�Sql Server2005���Ҳ��õķ�ʽ�Ƕ���һ��������Ȼ�����������schema�� : ����һ��set������Ȼ������select���������û���쳣���Ϳ���ͨ�� ��ȻҲ���Զ��� : һ���?��shema������ֶ��ϣ�Ȼ����������ݿ��ܷ�ɹ����ɹ��ͱ�ʾ���xml d : ata������schema ��֤�ģ������ҾͿ��Զ�data���в������������£� : .................������ʡ�ԣ� -- 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;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.29][m
Technical Details
Message-ID:
<4cMS73$aua@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,9461612e45b88811,start X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: ENGLISH,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS) Newsgroups: cn.bbs.comp.database Subject: Re: ����xml schema����֤������ Date: 08 Oct 2008 02:39:53 GMT Organization: ��ˮ˼Դ Message-ID: <4cMS73$aua@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1223433555.A