NCBI C++ ToolKit
blk_in.h
Go to the documentation of this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

Go to the SVN repository for this file.

1 char create_table_sql[] =
2 "CREATE TABLE all_types_bcp_unittest (\n"
3 " not_null_bit bit NOT NULL\n"
4 "\n"
5 " , not_null_char char(10) NOT NULL\n"
6 " , not_null_varchar varchar(10) NOT NULL\n"
7 "\n"
8 " , not_null_datetime datetime NOT NULL\n"
9 " , not_null_smalldatetime smalldatetime NOT NULL\n"
10 "\n"
11 " , not_null_money money NOT NULL\n"
12 " , not_null_smallmoney smallmoney NOT NULL\n"
13 "\n"
14 " , not_null_float float NOT NULL\n"
15 " , not_null_real real NOT NULL\n"
16 "\n"
17 " , not_null_decimal decimal(5,2) NOT NULL\n"
18 " , not_null_numeric numeric(5,2) NOT NULL\n"
19 "\n"
20 " , not_null_int int NOT NULL\n"
21 " , not_null_smallint smallint NOT NULL\n"
22 " , not_null_tinyint tinyint NOT NULL\n"
23 "\n"
24 " , nullable_char char(10) NULL\n"
25 " , nullable_varchar varchar(10) NULL\n"
26 "\n"
27 " , nullable_datetime datetime NULL\n"
28 " , nullable_smalldatetime smalldatetime NULL\n"
29 "\n"
30 " , nullable_money money NULL\n"
31 " , nullable_smallmoney smallmoney NULL\n"
32 "\n"
33 " , nullable_float float NULL\n"
34 " , nullable_real real NULL\n"
35 "\n"
36 " , nullable_decimal decimal(5,2) NULL\n"
37 " , nullable_numeric numeric(5,2) NULL\n"
38 "\n"
39 " , nullable_int int NULL\n"
40 " , nullable_smallint smallint NULL\n"
41 " , nullable_tinyint tinyint NULL\n"
42 "\n"
43 " /* Excludes: \n"
44 " * binary\n"
45 " * image\n"
46 " * uniqueidentifier\n"
47 " * varbinary\n"
48 " * text\n"
49 " * timestamp\n"
50 " * nchar\n"
51 " * ntext\n"
52 " * nvarchar\n"
53 " */\n"
54 ")\n"
55 "\n"
56 "INSERT all_types_bcp_unittest \n"
57 "VALUES ( 1 -- not_null_bit\n"
58 "\n"
59 " , 'a' -- not_null_char\n"
60 " , 'a' -- not_null_varchar\n"
61 "\n"
62 " , 'Dec 17 2003 3:44PM' -- not_null_datetime\n"
63 " , 'Dec 17 2003 3:44PM' -- not_null_smalldatetime\n"
64 "\n"
65 " , 12.34 -- not_null_money\n"
66 " , 12.34 -- not_null_smallmoney\n"
67 "\n"
68 " , 12.34 -- not_null_float\n"
69 " , 12.34 -- not_null_real\n"
70 "\n"
71 " , 12.34 -- not_null_decimal\n"
72 " , 12.34 -- not_null_numeric\n"
73 "\n"
74 " , 1234 -- not_null_int\n"
75 " , 1234 -- not_null_smallint\n"
76 " , 123 -- not_null_tinyint\n"
77 "\n"
78 " , 'a' -- nullable_char\n"
79 " , 'a' -- nullable_varchar\n"
80 "\n"
81 " , 'Dec 17 2003 3:44PM' -- nullable_datetime\n"
82 " , 'Dec 17 2003 3:44PM' -- nullable_smalldatetime\n"
83 "\n"
84 " , 12.34 -- nullable_money\n"
85 " , 12.34 -- nullable_smallmoney\n"
86 "\n"
87 " , 12.34 -- nullable_float\n"
88 " , 12.34 -- nullable_real\n"
89 "\n"
90 " , 12.34 -- nullable_decimal\n"
91 " , 12.34 -- nullable_numeric\n"
92 "\n"
93 " , 1234 -- nullable_int\n"
94 " , 1234 -- nullable_smallint\n"
95 " , 123 -- nullable_tinyint\n"
96 ")\n"
97 "INSERT all_types_bcp_unittest\n"
98 " ( not_null_bit \n"
99 "\n"
100 " , not_null_char \n"
101 " , not_null_varchar \n"
102 "\n"
103 " , not_null_datetime \n"
104 " , not_null_smalldatetime \n"
105 "\n"
106 " , not_null_money \n"
107 " , not_null_smallmoney \n"
108 "\n"
109 " , not_null_float \n"
110 " , not_null_real \n"
111 "\n"
112 " , not_null_decimal \n"
113 " , not_null_numeric \n"
114 "\n"
115 " , not_null_int \n"
116 " , not_null_smallint \n"
117 " , not_null_tinyint \n"
118 " ) \n"
119 "VALUES (\n"
120 " 1 -- not_null_bit\n"
121 "\n"
122 " , 'a' -- not_null_char\n"
123 " , 'a' -- not_null_varchar\n"
124 "\n"
125 " , 'Dec 17 2003 3:44PM' -- not_null_datetime\n"
126 " , 'Dec 17 2003 3:44PM' -- not_null_smalldatetime\n"
127 "\n"
128 " , 12.34 -- not_null_money\n"
129 " , 12.34 -- not_null_smallmoney\n"
130 "\n"
131 " , 12.34 -- not_null_float\n"
132 " , 12.34 -- not_null_real\n"
133 "\n"
134 " , 12.34 -- not_null_decimal\n"
135 " , 12.34 -- not_null_numeric\n"
136 "\n"
137 " , 1234 -- not_null_int\n"
138 " , 1234 -- not_null_smallint\n"
139 " , 123 -- not_null_tinyint\n"
140 ")\n";
141 
char create_table_sql[]
Definition: blk_in.h:1
Modified on Tue Apr 09 07:56:03 2024 by modify_doxy.py rev. 669887
Modified on Wed Apr 10 07:31:29 2024 by modify_doxy.py rev. 669887
Modified on Thu Apr 11 15:03:08 2024 by modify_doxy.py rev. 669887
Modified on Fri Apr 12 17:15:09 2024 by modify_doxy.py rev. 669887
Modified on Sat Apr 13 11:43:43 2024 by modify_doxy.py rev. 669887
Modified on Sun Apr 14 05:24:45 2024 by modify_doxy.py rev. 669887
Modified on Tue Apr 16 20:07:35 2024 by modify_doxy.py rev. 669887
Modified on Wed Apr 17 13:08:16 2024 by modify_doxy.py rev. 669887
Modified on Sat Apr 20 12:15:00 2024 by modify_doxy.py rev. 669887
Modified on Sun Apr 21 03:38:12 2024 by modify_doxy.py rev. 669887