
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 · 255 阅读 · 0 评论 -
MsSql批量修改备注 导出批量修改字段注释语句
MsSql导出批量修改字段注释语句SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description , 'if exists (SELECT1FROM sys.tables AINNER JOIN sys.columns B ON B.object_id = A.object_...原创 2018-12-13 00:17:32 · 913 阅读 · 0 评论