CREATE TABLE [BackSale] (
[BackSale_ID] [numeric] IDENTITY (1, 1)(18,0) NOT NULL,
[Product_ID] [varchar] (50) NOT NULL,
[ProductName] [varchar] (20) NOT NULL,
[Number] [numeric] (18,0) NOT NULL,
[Price] [numeric] (19,4) NOT NULL,
[JtDate] [varchar] (30) NOT NULL,
[SuperMarket] [varchar] (16) NOT NULL,
[NextBack] [char] (1) NOT NULL,
[reason] [varchar] (250) NULL)CREATE TABLE [Sale] (
[Sale_ID] [numeric] IDENTITY (1, 1) (18,0) NOT NULL,
[ProductID] [varchar] (10) NOT NULL,
[SaleDate] [varchar] (50) NOT NULL,
[Number] [numeric] (10,0) NOT NULL,
[Price] [numeric] (19,4) NOT NULL,
[Discount] [varchar] (10) NOT NULL,
[VIP_ID] [varchar] (10) NULL,
[ProductName] [varchar] (50) NOT NULL)CREATE TABLE [StockPile] (
[ID] [numeric] IDENTITY (1, 1) (18,0) NOT NULL,
[MerchandiseNumber] [varchar] (20) NOT NULL,
[number] [numeric] (18,0) NULL DEFAULT (10000))后缀名SQL导入2008时候执行错误,错误消息 102,级别 15,状态 1,第 5 行
'(' 附近有语法错误。
消息 102,级别 15,状态 1,第 152 行
'(' 附近有语法错误。
消息 102,级别 15,状态 1,第 227 行
'(' 附近有语法错误。
在线等,加急
[BackSale_ID] [numeric] IDENTITY (1, 1)(18,0) NOT NULL,
[Product_ID] [varchar] (50) NOT NULL,
[ProductName] [varchar] (20) NOT NULL,
[Number] [numeric] (18,0) NOT NULL,
[Price] [numeric] (19,4) NOT NULL,
[JtDate] [varchar] (30) NOT NULL,
[SuperMarket] [varchar] (16) NOT NULL,
[NextBack] [char] (1) NOT NULL,
[reason] [varchar] (250) NULL)CREATE TABLE [Sale] (
[Sale_ID] [numeric] IDENTITY (1, 1) (18,0) NOT NULL,
[ProductID] [varchar] (10) NOT NULL,
[SaleDate] [varchar] (50) NOT NULL,
[Number] [numeric] (10,0) NOT NULL,
[Price] [numeric] (19,4) NOT NULL,
[Discount] [varchar] (10) NOT NULL,
[VIP_ID] [varchar] (10) NULL,
[ProductName] [varchar] (50) NOT NULL)CREATE TABLE [StockPile] (
[ID] [numeric] IDENTITY (1, 1) (18,0) NOT NULL,
[MerchandiseNumber] [varchar] (20) NOT NULL,
[number] [numeric] (18,0) NULL DEFAULT (10000))后缀名SQL导入2008时候执行错误,错误消息 102,级别 15,状态 1,第 5 行
'(' 附近有语法错误。
消息 102,级别 15,状态 1,第 152 行
'(' 附近有语法错误。
消息 102,级别 15,状态 1,第 227 行
'(' 附近有语法错误。
在线等,加急
[BackSale_ID] [numeric](18,0) IDENTITY (1, 1) NOT NULL,
[Product_ID] [varchar] (50) NOT NULL,
[ProductName] [varchar] (20) NOT NULL,
[Number] [numeric] (18,0) NOT NULL,
[Price] [numeric] (19,4) NOT NULL,
[JtDate] [varchar] (30) NOT NULL,
[SuperMarket] [varchar] (16) NOT NULL,
[NextBack] [char] (1) NOT NULL,
[reason] [varchar] (250) NULL)CREATE TABLE [Sale] (
[Sale_ID] [numeric](18,0) IDENTITY (1, 1) NOT NULL,
[ProductID] [varchar] (10) NOT NULL,
[SaleDate] [varchar] (50) NOT NULL,
[Number] [numeric] (10,0) NOT NULL,
[Price] [numeric] (19,4) NOT NULL,
[Discount] [varchar] (10) NOT NULL,
[VIP_ID] [varchar] (10) NULL,
[ProductName] [varchar] (50) NOT NULL)CREATE TABLE [StockPile] (
[ID] [numeric](18,0) IDENTITY (1, 1) NOT NULL,
[MerchandiseNumber] [varchar] (20) NOT NULL,
[number] [numeric] (18,0) NULL DEFAULT (10000))
将所有表的id,(18,0) 放在类型后面如下,
[Sale_ID] [numeric](18,0) IDENTITY (1, 1) NOT NULL,
为什么用numeric 如果 identity 使用的int
sale_id int identity(1,1) not null