From 63f97a810a8dcd213f4624533aa52f7bc2647d49 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 24 八月 2021 13:50:53 +0800 Subject: [PATCH] 提交 --- 表修改.sql | 70 +++++++++++++++++++++++++++++++++++ 1 files changed, 70 insertions(+), 0 deletions(-) diff --git "a/\350\241\250\344\277\256\346\224\271.sql" "b/\350\241\250\344\277\256\346\224\271.sql" index 83cda16..a60ca31 100644 --- "a/\350\241\250\344\277\256\346\224\271.sql" +++ "b/\350\241\250\344\277\256\346\224\271.sql" @@ -1,6 +1,76 @@ USE [zhengcaioa] GO +ALTER TABLE [dbo].[adm_goods_manage] ADD [haocai_status] [nvarchar](1) DEFAULT ('D') +GO + + +update [adm_goods_manage] set [haocai_status]='D' +GO + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +USE [zhengcaioa] +GO + /****** Object: Table [dbo].[ADM_Customer_withdrawal] Script Date: 2021/8/9 13:43:29 ******/ SET ANSI_NULLS ON GO -- Gitblit v1.9.1