![](https://img-blog.csdnimg.cn/20201109113625977.jpg?x-oss-process=image/resize,m_fixed,h_224,w_224)
SQL技术
数据库技术
飓风部落格
坚持写
展开
-
用脚本 生成 日历表
MSQL 语句 CREATE TABLE [dbo].[Calendar] ( [time_id] [int] IDENTITY (1, 1) NOT NULL primary key, [the_date] [datetime] NULL , [the_day] [nvarchar] (15) NULL , [the_month] [nvarchar] (15) NULL , [the_year] [smallint] NULL , [day_of..原创 2020-11-09 11:40:58 · 226 阅读 · 0 评论 -
MsSql批量修改备注 导出批量修改字段注释语句
MsSql导出批量修改字段注释语句 SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description , ' if exists ( SELECT 1 FROM sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object_...原创 2018-12-13 00:17:32 · 861 阅读 · 0 评论