Одно и то же, но какое различие
1. Выполнить
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
INSERT INTO [INVTRBATCH] (
ID
,PARTITION
,OWNER
,PDATE
,BATCHNUM
,SFNUM
,WHID
,DESCR
,ST
,POSTCODE)
SELECT
'{8BACA9F9-F907-4DEE-98B9-453026697DF2}'
,'71'
,'admin'
,'2006-03-01'
,'432'
,NULL
,'{4276D794-F352-4736-A437-2C84BCDA5ABD}'
,NULL
, 0
,NULL;
2.1 Переслать в виде
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:updatable="true">
- <s:AttributeType name="ID" rs:number="1" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="ID" rs:keycolumn="true">
<s:datatype dt:type="uuid" dt:maxLength="16" rs:fixedlength="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="PARTITION" rs:number="2" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="PARTITION">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="24" />
</s:AttributeType>
- <s:AttributeType name="OWNER" rs:number="3" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="OWNER">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="24" />
</s:AttributeType>
- <s:AttributeType name="PDATE" rs:number="4" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="PDATE">
<s:datatype dt:type="dateTime" rs:dbtype="timestamp" dt:maxLength="16" rs:scale="3" rs:precision="23" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="BATCHNUM" rs:number="5" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="BATCHNUM">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="24" />
</s:AttributeType>
- <s:AttributeType name="SFNUM" rs:number="6" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="SFNUM">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="24" />
</s:AttributeType>
- <s:AttributeType name="WHNAME" rs:number="7" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="ORG" rs:basecolumn="DESCR">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="250" />
</s:AttributeType>
- <s:AttributeType name="WHID" rs:number="8" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="WHID">
<s:datatype dt:type="uuid" dt:maxLength="16" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="OPRNAME" rs:number="9" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="POSTGROUPS" rs:basecolumn="DESCR">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="150" />
</s:AttributeType>
- <s:AttributeType name="DESCR" rs:number="10" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="DESCR">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="150" />
</s:AttributeType>
- <s:AttributeType name="ST" rs:number="11" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="ST">
<s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="POSTCODE" rs:number="12" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="INVTRBATCH" rs:basecolumn="POSTCODE">
<s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="AMOUNT" rs:number="13" rs:nullable="true">
<s:datatype dt:type="float" dt:maxLength="8" rs:precision="15" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="c13" rs:name="ID" rs:number="14" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="ORG" rs:basecolumn="ID" rs:keycolumn="true" rs:hidden="true">
<s:datatype dt:type="uuid" dt:maxLength="16" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="CODE" rs:number="15" rs:nullable="true" rs:writeunknown="true" rs:basecatalog="KSP" rs:basetable="POSTGROUPS" rs:basecolumn="CODE" rs:keycolumn="true" rs:hidden="true">
<s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
<z:row ID="{A08A8682-B2A0-4A74-8F2B-CE0AAE951BCB}" PARTITION="71" OWNER="admin" PDATE="2006-02-01T00:00:00" BATCHNUM="001620" WHNAME="1257/б" WHID="{B2E5F078-5277-4B51-ADA4-988C74B6F52A}" OPRNAME="Реализация розница (буфеты)" ST="0" POSTCODE="9" AMOUNT="83" c13="{B2E5F078-5277-4B51-ADA4-988C74B6F52A}" CODE="9" />
</rs:data>
</xml>
2.2 Преобразовать к форме 1
2.3 Выполнить
Это я к тому, что переводчиков нанимают от собственной лени. Всегда лучше знать язык который понимает тот, с кем ты собираешься общаться.
Извиняюсь за длинный текст, короче увы не получается :)
И что самое интересное. Если у принимающей стороны нет места, куда это положить, результат будет один и тот же.
