?? 點擊關注不迷路
?? 點擊關注不迷路
?? 點擊關注不迷路

---

一、Microsoft SQL Server-2017，環境搭建命令

• 鏡像拉取，運行；2022或最新版本一直異常，通過老版本完成代碼研發

  docker pull mcr.microsoft.com/mssql/server:2017-latestdocker run -e ACCEPT_EULA=Y -e MSSQL_PID='Developer' -e MSSQL_SA_PASSWORD='fanmukeji.1234567' -e MSSQL_TCP_PORT=1234 -p 1234:1234 -d mcr.microsoft.com/mssql/server:2017-latest
  

二、借助 @@VERSION 函數來查看當前版本

• select @@version;
  

三、查詢Microsoft SQL Server數據庫、表名、表注釋

• SELECTs.name AS schema_name,t.name AS table_name,ISNULL(ep.value, '') AS table_comment
  FROMsys.schemas s
  JOINsys.tables t ON s.schema_id = t.schema_id
  LEFT JOINsys.extended_properties ep ON t.object_id = ep.major_id AND ep.minor_id = 0 AND ep.name = 'MS_Description';-- 查詢Microsoft SQL Server數據庫名、數據表名、字段名、字段類型、字段類型長度、非空、主鍵、是否索引
  SELECTt.name AS table_name, c.name AS column_name,ISNULL(ep.value, '') AS column_comment, ty.name AS column_type,CASE WHEN ty.name IN ('varchar', 'char', 'nvarchar', 'nchar') THEN c.max_lengthWHEN ty.name IN ('decimal', 'numeric') THEN c.precisionELSE NULL END AS column_length,CASE WHEN c.is_nullable = 1 THEN '否' ELSE '是'