插入列语句:ALTER TABLE 表名 ADD 列名1 bit(解释:数据类型) null(解释:是否可以空),列名2 nvarchar(40) null;
创建表语句:
CREATE TABLE [dbo].[订单](
[_Identify] [int] IDENTITY(1,1) NOT NULL,
[_Locked] [bit] NULL,
[_SortKey] [numeric](28, 14) NULL,
[订单编号] [nvarchar](40) NULL,
[成品名称] [nvarchar](150) NULL,
[规格型号] [nvarchar](16) NULL,
[数量] [int] NULL,
[适用矿区] [nvarchar](200) NULL,
[录入日期] [datetime] NULL,
[修改日期] [datetime] NULL,
[是否删除] [bit] NULL,
[总重量] [float] NULL,
[消耗总金额] [float] NULL,
[加工总金额] [float] NULL,
[合计总金额] [float] NULL,
CONSTRAINT [PrimaryKey_订单] PRIMARY KEY NONCLUSTERED
(
[_Identify] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO