@oflyhigh: 补充：查询所有数据库名老方法： | Ecency

RE: RE: 每天进步一点点：再捡PyMSSQL 以及一些或许有用的查询

You are viewing a single comment's thread from:

RE: 每天进步一点点：再捡PyMSSQL 以及一些或许有用的查询

View the full context

Published in

HIVE CN 中文社区

Words

26

Reading

1 min

Listen

Play

6y

补充：查询所有数据库名

老方法：

SELECT Name FROM Master..SysDatabases ORDER BY Name

新方法：

SELECT name FROM sys.databases

参考链接：

https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-a-list-of-databases-on-an-instance-of-sql-server?view=sql-server-ver15

This post was published via hiveblog. Ecency is not the originator or editor of this content and displays it for discovery purposes only.

$ 0.669

1

@oflyhigh: 补充：查询所有数据库名老方法： | Ecency