传输麻黄碱出错数据库执行

wbv123

if object_id(‘d_ware_xq’) is not null drop table d_ware_xq

CREATE TABLE [dbo].[d_ware_xq](
[wareid] varchar NULL,
[barcode] varchar NULL,
[abc] varchar NULL,
[warename] varchar NULL,
[waresimname] varchar NULL,
[warespec] varchar NULL,
[prod_add] varchar NULL,
[producer] varchar NULL,
[waretype] char NULL,
[stamp] [timestamp] NULL,
[bak1] varchar NULL,
[bak2] varchar NULL,
[bak3] varchar NULL,
[bak4] varchar NULL,
[bak5] varchar NULL,
[bak6] [numeric](14, 4) NULL,
[bak7] [numeric](14, 4) NULL,
[bak8] [numeric](14, 4) NULL,
[bak9] [datetime] NULL,
[bak10] [datetime] NULL,
[bak11] varchar NULL,
[bak12] [numeric](16, 6) NULL,
[promno] varchar NULL
) ON [PRIMARY]

go

if object_id(‘d_麻黄碱购药登记’) is not null drop table d_麻黄碱购药登记

CREATE TABLE [dbo].[d_麻黄碱购药登记](
[id] varchar NOT NULL,
[saleno] varchar NULL,
[buyuser] varchar NULL,
[icno] varchar NULL,
[reason] varchar NULL,
[tel] varchar NULL,
[docuter] varchar NULL,
[createtime] [datetime] NULL,
[payee] varchar NULL,
[notes] varchar NULL,
[checkbit1] [int] NULL,
[checker1] varchar NULL,
[checkbit2] [int] NULL,
stamp timestamp,
[checker2] varchar NULL,

) ON [PRIMARY]
go