sqlserver一些区别mysql基本命令

1.查看表名

SELECT name FROM sys.tables

 

2.查看表结构（使用sp_help 查看表结构）

EXEC sp_help 'table_name';

 

3.查看数据库默认排序规则（Collation）

SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation') AS DatabaseCollation;

 

4.安某列的日期时间的某部分（日期）排序

①CONVERT()函数

SELECT
　　CONVERT(DATE, column_name) AS DateOnly,
　　COUNT(*) AS TotalCount
FROM
　　table_name
GROUP BY
　　CONVERT(DATE, column_name)
ORDER BY
　　DateOnly;

②CAST() 函数

SELECT
　　CAST(column_name AS DATE) AS DateOnly,
　　COUNT(*) AS TotalCount
FROM
　　table_name
GROUP BY
　　CAST(column_name AS DATE)
ORDER BY
　　DateOnly;

 

③时间用time 

SELECT   CONVERT(TIME, column_name)  FROM   table_name

SELECT   CAST(column_name AS TIME)  FROM   table_name