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
55
56
57
58
59
60
61
62
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105165"><META NAME="lcid" CONTENT="1033"><title>SQLTypeType simpleType</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>SQLTypeType simpleType</h1><p>Specifies the SQL data type of a query parameter or PivotTable field.</p><h2>Type Information</h2><table>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<xsd:simpleType name="SQLTypeType" >
<xsd:restriction base="xsd:string">
<xsd:enumeration value="BigInteger" />
<xsd:enumeration value="Binary" />
<xsd:enumeration value="Bit" />
<xsd:enumeration value="Character" />
<xsd:enumeration value="Date" />
<xsd:enumeration value="Decimal" />
<xsd:enumeration value="Double" />
<xsd:enumeration value="Float" />
<xsd:enumeration value="GUID" />
<xsd:enumeration value="Integer" />
<xsd:enumeration value="LongVariableBinary" />
<xsd:enumeration value="LongVariableCharacter" />
<xsd:enumeration value="Numeric" />
<xsd:enumeration value="Real" />
<xsd:enumeration value="SignedBigInteger" />
<xsd:enumeration value="SignedInteger" />
<xsd:enumeration value="SignedSmallInteger" />
<xsd:enumeration value="SignedTinyInteger" />
<xsd:enumeration value="SmallInteger" />
<xsd:enumeration value="Time" />
<xsd:enumeration value="TimeStamp" />
<xsd:enumeration value="TinyInteger" />
<xsd:enumeration value="Unknown" />
<xsd:enumeration value="UnsignedBigInteger" />
<xsd:enumeration value="UnsignedInteger" />
<xsd:enumeration value="UnsignedSmallInteger" />
<xsd:enumeration value="UnsignedTinyInteger" />
<xsd:enumeration value="VariableBinary" />
<xsd:enumeration value="VariableCharacter" />
<xsd:enumeration value="WideCharacter" />
<xsd:enumeration value="WideLongVariableCharacter" />
<xsd:enumeration value="WideVariableCharacter" />
</xsd:restriction>
</xsd:simpleType>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
