floor mod sqlserver_sqlserver更新表脚本

小鱼儿 2022-12-31 15:18 200阅读 0赞

\--增加项目字段,门店信息，所在省份，所在市，所在区县，提供服务

ALTER TABLE \[dbo\].\[school\_base\_info\]

ADD \[store\_information\] varchar(32) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'school\_base\_info',

'COLUMN', N'store\_information')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'门店信息'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_information'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'门店信息'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_information'

ALTER TABLE \[dbo\].\[school\_base\_info\]

ADD \[store\_in\_province\] varchar(32) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'school\_base\_info',

'COLUMN', N'store\_in\_province')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'所在省份'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_in\_province'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'所在省份'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_in\_province'

ALTER TABLE \[dbo\].\[school\_base\_info\]

ADD \[store\_in\_city\] varchar(32) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'school\_base\_info',

'COLUMN', N'store\_in\_city')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'所在市'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_in\_city'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'所在市'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_in\_city'

ALTER TABLE \[dbo\].\[school\_base\_info\]

ADD \[store\_in\_area\] varchar(32) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'school\_base\_info',

'COLUMN', N'store\_in\_area')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'所在区县'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_in\_area'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'所在区县'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_in\_area'

ALTER TABLE \[dbo\].\[school\_base\_info\]

ADD \[store\_support\] varchar(512) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'school\_base\_info',

'COLUMN', N'store\_support')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'提供服务'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_support'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'提供服务'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'school\_base\_info'

, @level2type = 'COLUMN', @level2name = N'store\_support'

\--增加会员信息表字段，邀请人ID，是否已下单,会员类型

ALTER TABLE \[dbo\].\[sys\_common\_user\]

ADD \[invitor\_id\] varchar(32) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'sys\_common\_user',

'COLUMN', N'invitor\_id')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'邀请人ID'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'sys\_common\_user'

, @level2type = 'COLUMN', @level2name = N'invitor\_id'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'邀请人ID'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'sys\_common\_user'

, @level2type = 'COLUMN', @level2name = N'invitor\_id'

ALTER TABLE \[dbo\].\[sys\_common\_user\]

ADD \[is\_order\] varchar(2) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'sys\_common\_user',

'COLUMN', N'is\_order')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'是否已下单'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'sys\_common\_user'

, @level2type = 'COLUMN', @level2name = N'is\_order'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'是否已下单'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'sys\_common\_user'

, @level2type = 'COLUMN', @level2name = N'is\_order'

ALTER TABLE \[dbo\].\[sys\_common\_user\]

ADD \[user\_type\] varchar(32) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'sys\_common\_user',

'COLUMN', N'user\_type')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'会员类型'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'sys\_common\_user'

, @level2type = 'COLUMN', @level2name = N'user\_type'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'会员类型'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'sys\_common\_user'

, @level2type = 'COLUMN', @level2name = N'user\_type'

//增加商品表字段，商品低价

ALTER TABLE \[dbo\].\[food\_base\_info\]

ADD \[floor\] decimal(8,2) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'food\_base\_info',

'COLUMN', N'floor')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'商品底价'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'food\_base\_info'

, @level2type = 'COLUMN', @level2name = N'floor'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'商品底价'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'food\_base\_info'

, @level2type = 'COLUMN', @level2name = N'floor'

ALTER TABLE \[dbo\].\[food\_base\_info\]

ADD \[food\_kind\] varchar(2) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'food\_base\_info',

'COLUMN', N'kind')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'商品种类'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'food\_base\_info'

, @level2type = 'COLUMN', @level2name = N'kind'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'商品种类'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'food\_base\_info'

, @level2type = 'COLUMN', @level2name = N'kind'

//增加订单表字段，修改次数，订单完成时间

ALTER TABLE \[dbo\].\[order\_main\_info\]

ADD \[mod\_time\] varchar(2) NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'order\_main\_info',

'COLUMN', N'mod\_time')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'修改次数'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'order\_main\_info'

, @level2type = 'COLUMN', @level2name = N'mod\_time'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'修改次数'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'order\_main\_info'

, @level2type = 'COLUMN', @level2name = N'mod\_time'

ALTER TABLE \[dbo\].\[order\_main\_info\]

ADD \[complete\_time\] datetime NULL

IF ((SELECT COUNT(\*) from fn\_listextendedproperty('MS\_Description',

'SCHEMA', N'dbo',

'TABLE', N'order\_main\_info',

'COLUMN', N'complete\_time')) > 0)

EXEC sp\_updateextendedproperty @name = N'MS\_Description', @value = N'订单完成时间'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'order\_main\_info'

, @level2type = 'COLUMN', @level2name = N'complete\_time'

ELSE

EXEC sp\_addextendedproperty @name = N'MS\_Description', @value = N'订单完成时间'

, @level0type = 'SCHEMA', @level0name = N'dbo'

, @level1type = 'TABLE', @level1name = N'order\_main\_info'

, @level2type = 'COLUMN', @level2name = N'complete\_time'

floor mod sqlserver_sqlserver更新表脚本

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql 动态更新数据库_动态更新数据库脚本——Mysql

相关 floor mod sqlserver_sqlserver更新表脚本

相关 Windows脚本汇总（持续更新）

相关批量更新软连接脚本

相关 oracle floor

相关 Mod （二分法）

相关 shell 脚本更新azkaban job

相关 mod_rewrite

相关 sims算法_如何保持“ Sims 4” Mod更新

相关 C. Floor and Mod (分块整除)