香腸炒章魚

SQL Server 2017 金鑰 (key)：
Enterprise Core：6GPYM-VHN83-PHDM2-Q9T2R-KBV83

最近在安裝 SQL Server Express 2017 一直無法安裝，出現以下錯誤訊息。
 

當已安裝某種語系的 SSMS 之後，在移除之後再重新安裝別的語系的 SSMS ，會無法正確顯示正確的語系，該怎麼樣來解決呢 ?
 
 
 

SSMS 是整合式環境，用於管理任何 SQL 基礎結構，從 SQL Sever 到 Azure SQL Database 皆適用。
SSMS 提供工具來設定、監視和管理 SQL 執行個體。
使用 SSMS，即可部署、監視和升級應用程式所使用的資料層元件，以及建置查詢和指令碼。

匯入及匯出主要是討論「大量資料」(Bulk Data)的傳送問題，SQL Server也提供了數種方法以處理不同情境下的匯入匯出
作業。
 
使用匯入匯出精靈

在 Database Engine 查詢編輯器顯示行號
 
1、在 SQL Server Management Studio 上方功能表按【工具】，選擇【選項】。
 

如何將 SQL Server Management Studio 設定為顯示行號。
 
開啟 SSMS 之後，選擇「工具」，點選「選項」。

Table 10.2 Type mapping


Source TypeMySQL TypeComment



INT
INT
 


TINYINT
TINYINT
UNSIGNED flag set in MySQL


SMALLINT
SMALLINT
 


BIGINT
BIGINT
 


BIT
TINYINT(1)
 


FLOAT
FLOAT
Precision value is used for storage size in both


REAL
FLOAT
 


NUMERIC
DECIMAL
 


DECIMAL
DECIMAL
 


MONEY
DECIMAL
 


SMALLMONEY
DECIMAL
 


CHAR
CHAR/LONGTEXT
Depending on its length. MySQL Server 5.5 and above can have CHAR columns with a length up to 255 characters. Anything larger is migrated as LONGTEXT


NCHAR
CHAR/LONGTEXT
Depending on its length. MySQL Server 5.5 and above can have VARCHAR columns with a length up to 65535 characters. Anything larger is migrated to one of the TEXT blob types. In MySQL, character set of strings depend on the column character set instead of the datatype.


VARCHAR
VARCHAR/MEDIUMTEXT/LONGTEXT
Depending on its length. MySQL Server 5.5 and above can have VARCHAR columns with a length up to 65535 characters. Anything larger is migrated to one of the TEXT blob types.


NVARCHAR
VARCHAR/MEDIUMTEXT/LONGTEXT
Depending on its length. MySQL Server 5.5 and above can have VARCHAR columns with a length up to 65535 characters. Anything larger is migrated to one of the TEXT blob types. In MySQL, character set of strings depend on the column character set instead of the datatype.


DATE
DATE
 


DATETIME
DATETIME
 


DATETIME2
DATETIME
Date range in MySQL is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999'. Note: fractional second values are only stored as of MySQL Server 5.6.4


SMALLDATETIME
DATETIME
 


DATETIMEOFFSET
DATETIME
 


TIME
TIME
 


TIMESTAMP
TIMESTAMP
 


ROWVERSION
TIMESTAMP
 


BINARY
BINARY/MEDIUMBLOB/LONGBLOB
Depending on its length


VARBINARY
VARBINARY/MEDIUMBLOB/LONGBLOB
Depending on its length


TEXT
VARCHAR/MEDIUMTEXT/LONGTEXT
Depending on its length


NTEXT
VARCHAR/MEDIUMTEXT/LONGTEXT
Depending on its length


IMAGE
TINYBLOB/MEDIUMBLOB/LONGBLOB
Depending on its length


SQL_VARIANT
not migrated
There is not specific support for this datatype.


TABLE
not migrated
There is not specific support for this datatype.


HIERARCHYID
not migrated
There is not specific support for this datatype.


UNIQUEIDENTIFIER
VARCHAR(64)
A unique flag set in MySQL. There is not specific support for inserting unique identifier values.


SYSNAME
VARCHAR(160)
 


XML
TEXT
 

如何將一個資料庫「附加」到 SQL Server 上？
* 假設我們有個「圖書銷售.mdf」資料庫。
* 附加資料庫，利用 SQL Server Management Studio 工具。
  

SQL Server 系統預設的登入帳戶
* sa 帳戶。
* 網域(本機)名稱\Administrator、BUILTIN\Administrators。
* NT AUTHORITY/NETWORK SERVICES 及 NT AUTHORITY/SYSTEM。