SQL另存的可以不可以生成另一种格试。原来是CREATE TABLE bld55 (
item_no char(8),
item_subno char(25),
item_barcode char(25),
item_name char(60),
item_class char(20),
item_brand char(4),
item_size char(30),
item_unit_no char(10),
item_area char(30),
item_grade char(30),
item_sup_no char(12),
counter_no char(4),
item_in_price decimal(16, 6),
item_sale_price decimal(16, 6),
item_pf_price decimal(16, 6),
item_vip_price decimal(16, 6),
in_tax_rate decimal(16, 6),
out_tax_rate decimal(16, 6),
item_valid_day decimal(16, 6),
item_valid_tipday decimal(16, 6),
item_memo char(255),
item_bytxt1 char(255),
item_bytxt2 char(255),
item_bytxt3 char(255),
item_bynum1 decimal(16, 6),
item_bynum2 decimal(16, 6),
item_bynum3 decimal(16, 6),
item_flag char(1),
display_flag char(1),
py_code char(30),
have_stock char(1),
allow_discount char(1),
change_price char(1),
integral_rate decimal(16, 6),
cost_type char(1),
internal_flag char(1),
create_date datetime,
create_user char(4),
modify_date datetime,
modify_user char(4),
lock_user char(4),
item_property char(4),
Manage_type char(1),
Manage_ly_rate decimal(16, 6),
item_dist_price decimal(16, 6),
item_combine char(1),
pos_discount decimal(16, 6),
pos_lower_price decimal(16, 6),
item_SaleMode char(1),
item_pf_rate decimal(16, 6),
item_sale_rate decimal(16, 6),
IsSysFlag char(1),
item_sale_ratetype char(1),
item_date_unit char(1),
item_pf_ratetype char(1),
showbox_no char(20),
item_in_ratetype char(1),
item_in_rate decimal(16, 6),
init_stock_qty decimal(16, 2),
item_IsGood char(1),
item_abc char(1),
item_print_label char(1),
item_qa_cert char(50),
item_qs_cert char(50),
item_inlet_cert char(50),
item_qi_rep char(255),
have_saleman char(1),
item_dist_qty decimal(16, 6),
item_dist_double char(1),
item_dist_limit char(2),
item_pzwh char(30),
item_factory char(50));
INSERT INTO bld55 VALUES (
'00007335',
'0100043',
'2000001000434',
'散装糖果',
'01',
'0',
NULL,
'',
NULL,
NULL,
'0',
'0',
0,
NULL,
NULL,
NULL,
0.170000,
0.170000,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'0',
'1',
'SZTG',
'1',
'1',
'1',
-1.000000,
'A',
'0',
'2012-5-9 9:11:7.936',
'1001',
'2012-5-9 9:11:7.936',
'1001',
'0',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
0,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'0-不可退',
NULL,
NULL,
NULL,
NULL,
'2-预淘汰',
NULL);。。。。。这样的不好加到表里。。。要直接给运行里追加的。如INSERT INTO 表 （字段1，字段2，字段3，字段4，.....）VALUES (值1，值2，值3，值4，。。。）