摘要：T-SQL语句处理顺序如下所示：(8) select (9) distinct (11) <top_specification> <select_list>(1) from <left_table>(3) <join_type> join <right_table>(2) on <join_condition>(4) where <where_condition>(5) group by <group_by_list>(6) with {cube|rollup}(7) having <havi 阅读全文

摘要：1、查询所有数据库名 mysql写法:show databases; sqlserver写法：select * from sys.databases;2、根据数据库名查询所有表名 mysql写法: show tables; sqlserver写法:use database select name from sys.objects where type='U'; //其中database为需要查找的数据库名3、根据表查询该表所有字段 mysql写法：show columns from table; sqlserver写法:select name from syscolumns w 阅读全文