sql出错求解

[88391788]

use db_test
createtable xz(
base_id intidentity(1,1)primarykey,
base_bhao varchar(8)notnulldefault'00000000',
base_name varchar(20)notnull,
base_dxin numeric(18,2)notnulldefault'0.00',
base_gwei numeric(18,2)notnulldefault'0.00',
base_jshu numeric(18,2)notnulldefault'0.00',
base_zjian numeric(18,2)notnulldefault'0.00',
base_canbu numeric(18,2)notnulldefault'0.00',
base_chaibu numeric(18,2)notnulldefault'0.00',

)

insertinto xz values('20101611','测试1','500','500','500','300','20','10')
insertinto xz values('20101612','测试2','500','300','500','300','20','10')
insertinto xz values('20101613','测试3','500','400','0','300','20','10')
insertinto xz values('20101614','测试4','500','1000','500','300','20','10')

[Tiger_Zhao]

要把除自增列之外的自动显式列出来。

insertinto xz(base_bhao,base_name,base_dxin,base_gwei,base_jshu,base_zjian,base_canbu,base_chaibu)
values('20101611','测试1','500','500','500','300','20','10')
insertinto xz(base_bhao,base_name,base_dxin,base_gwei,base_jshu,base_zjian,base_canbu,base_chaibu)
values('20101612','测试2','500','300','500','300','20','10')
insertinto xz(base_bhao,base_name,base_dxin,base_gwei,base_jshu,base_zjian,base_canbu,base_chaibu)
values('20101613','测试3','500','400','0','300','20','10')
insertinto xz(base_bhao,base_name,base_dxin,base_gwei,base_jshu,base_zjian,base_canbu,base_chaibu)
values('20101614','测试4','500','1000','500','300','20','10')

[阳泉酒家小当家]

我给修改了一下：

use db_test
go

create table xz(
base_id int identity(1,1) primary key,
        base_bhao varchar(8) not null default'00000000',
base_name varchar(20) not null,
base_dxin numeric(18,2) not null default'0.00',
base_gwei numeric(18,2) not null default'0.00',
base_jshu numeric(18,2) not null default'0.00',
base_zjian numeric(18,2) not null default'0.00',
base_canbu numeric(18,2) not null default'0.00',
base_chaibu numeric(18,2) not null default'0.00'
)

insert into xz values('20101611','测试1','500','500','500','300','20','10')
insert into xz values('20101612','测试2','500','300','500','300','20','10')
insert into xz values('20101613','测试3','500','400','0','300','20','10')
insert into xz values('20101614','测试4','500','1000','500','300','20','10')

[gw6328]

不会是 insertinto写一起了吧？