Linux修改时间命令
**查看当前系统时间** [root@localhost]# date Mon Jun 18 10:36:45 PDT 2018 **设置系统时间** [root@localhost]# date -s 21:48:00 Mon Jun 18 21:48:00 PDT 2018
分类 Default 下的文章
SqlServer查看表结构（字段名，说明，数据类型，长度，主键等）
SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE '' END AS 表名, col.colorder AS 序号 , col.name AS 列名 , ISNULL(ep.[value], '') AS 列说明 ,
SqlServer查看表信息（建立时间，更新时间）
SELECT [TableName] = [Tables].name , [TableCreateDate] = [Tables].create_date , [TableModifyDate] = [Tables].modify_date FROM sys.tables AS [Tables]
SqlServer查询空表
SELECT schema_name(t.schema_id) AS [Schema], t.name AS TableName, i.rows AS [RowCount] FROM sys.tables AS t INNER JOIN sys.sysindexes AS i ON t.object_id = i.id WHERE (i.indid <= 1) AND (i.rows = 0)
SqlServer 截取字符串函数
SELECT LEFT('SqlServer_2008',3) 返回：Sql SELECT RIGHT('SqlServer_2008',4) 返回：2008 SELECT SUBSTRING('SqlServer_2008',4,6) 返回：Server
