如何寫XML欄位的日期或數字表達式

[YuQ]

Dear Sirs,

�Ҵ���ʹ��XML��ʽ�탦��Data�����ڙz���r�������ڡ����ֻ��ִ���ȗl����Ӧ�����дSQL ���?
Ո���ˡ�

XML��λ�еă��ݣ�
<level type = 'Scene">
<metadata language_code = "zh-tw">
<column name="Team-Name">���ĈD˹</column>
<column name="Keywords">����,�W�ޱ�</column>
<column name="Title"/>
<column name="Win">4</column>
<column name="Last_session_time">Invalid Date</column>
</metadata>
<metadata language_code = "zh-cn">
<column name="Team-Name">����ͼ˹</column>
<column name="Keywords">����,ŷ�ޱ�</column>
<column name="Title">2009��ŷ�ޱ�����Ԥѡ��</column>
<column name="Win">4</column>
<column name="Last_session_time">Thu Sep 3 2009 03:43:17 PM</column>
</metadata>
</level>

Ҫ��ԃ�ă��ݣ�
1. ����r�g��λ����ָ��Ҫ��춻�С�ij�죬��ij��Datetime
2. Ҫ��ԃݔ�A���Σ����ܴ�춣�С춻���
3. Ҫ��������ƣ�����Keywords������Keyword�����а�

Best regards,

YuQ

[YuQ]

Dear Sirs��

- �����е�XMLֻ���ڶ��¼��һ�м�¼�µ�XML�ֶ��µ�����
- Ҫͨ��XML�е�Tag��Keyword��Value��ѯ�õ���¼

Ŀǰ�����������⣺
- ��Ҫ�˽������Where���������ֺ����ڣ������Ǵ����ڡ���ʱ�������ʱ�䣩������

��������֪��͵��ڡ��ַ���SQL��䣺
��
select asset_id, keyframe_set.query('//metadata/column')
from media_log
where
keyframe_set.exist('//metadata/column[@name="Keywords"]/text()[contains(.,"�yԇ")]')=1

����
select asset_id,
keyframe_set.query('//metadata/column[@name="Description"]')
from media_log
where keyframe_set.exist('//metadata/column[@name="Description"][. = "���o������"]')=1

�dz����

YuQ

"YuQ" <y...@jvschina.com> д����Ϣ����:eB1aXRUL...@TK2MSFTNGP02.phx.gbl...

"YuQ" <y...@jvschina.com> д����Ϣ����:OcGAhWQN...@TK2MSFTNGP05.phx.gbl...