qq_39001049的博客

USE [FTIR2017] GO /* Object: StoredProcedure [dbo].[Data_Ftir_ZeroFix] Script Date: 2018/8/4 15:51:55 */ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO – exec Data_Ftir_ZeroFix ‘2018-04-1...

USE [FTIR2017]GO/****** Object: StoredProcedure [dbo].[Data_Ftir_UnitFix] Script Date: 2018/8/4 16:18:35 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- exec Data_Ftir_UnitFix '2015...

1 判断数据库是否存在if exists (select * from sys.databases where name = '数据库名') drop database [数据库名] 2 判断表是否存在if exists (select * from sysobjects where id = object_id(N'[表名]') and OBJECTPROPERTY(...

1、单次查看表及字段备注show full columns from table.A;2、查看整个数据库内查看数据库内所有的表名、表备注、字段名称、字段类型、字段备注select t.TABLE_NAME ,t.TABLE_COMMENT ,c.COLUMN_NAME ,c.COLUMN_TYPE ,c.COLUMN_COMMENT from informat...