2014年数据库需要更新表字段说明

 天河   2019-06-17 11:39     0 条评论

IF  EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[CRM_orders]'))
DROP TABLE [dbo].[CRM_orders]
GO
CREATE TABLE [dbo].[CRM_orders](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Order_ID] [varchar](50) NOT NULL,
[Guest_UID] [varchar](50) NULL,
[Integral] [int] NULL,
[Amount] [money] NULL,
[IsUp] [int] NOT NULL,
[is_yd] [int] NOT NULL,
[yd_id] [varchar](50) NULL,
[ispayoff] [int] NOT NULL
) ON [PRIMARY]
GO

本文地址:http://www.softos.cn/2019/06/17/2014data/
版权声明:本文为原创文章,版权归 天河 所有,欢迎分享本文,转载请保留出处!

 发表评论


表情