Sponsored Links
目前分類：MSSQL Server (16)
- May 22 Wed 2019 12:47
[SQL Server] SQL Server 2012、2016、2017 繁簡中文版序號
- Dec 18 Tue 2018 16:33
[SQL][SERVER] 無法安裝、安裝發生錯誤、Error code 0x858C001B、SQL Server Express 2017
![[SQL][SERVER] 無法安裝、安裝發生錯誤、Erro](https://pic.pimg.tw/mitblog/1545183707-139192396.png "[SQL][SERVER] 無法安裝、安裝發生錯誤、Erro")
- Dec 07 Fri 2018 14:56
[SQL][SERVER] 變更 SQL Server Management Studio (SSMS) 語言、更改 SQL Server Management Studio (SSMS) 語系
- Dec 07 Fri 2018 14:37
[SQL][SERVER] 下載 SQL Server Management Studio (SSMS)、Download SQL Server Management Studio (SSMS)
SSMS 是整合式環境，用於管理任何 SQL 基礎結構，從 SQL Sever 到 Azure SQL Database 皆適用。
SSMS 提供工具來設定、監視和管理 SQL 執行個體。
- Dec 10 Sun 2017 22:12
[SQL][SERVER] SQL Server 的匯入匯出精靈（SQL Server Import and Export Wizard ,DTSWizard.exe）
- Dec 07 Thu 2017 17:57
[SQL][SERVER] 如何在 Database Engine 查詢編輯器顯示行號與列印內容包含行號
- Nov 11 Sat 2017 21:20
[SQL][SERVER] Microsoft SQL Server Management Studio 顯示行號
- Oct 28 Sat 2017 12:07
[SQL][SERVER] Microsoft SQL Server Type Mapping
Table 10.2 Type mapping
| Source Type | MySQL Type | Comment |
|---|---|---|
| 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 |
- Nov 30 Wed 2016 11:34
[SQL][SERVER] 附加資料庫到 SQL Server 上
- Nov 29 Tue 2016 14:55
[SQL][SERVER] 登入帳戶的建立與管理
- Oct 05 Mon 2015 20:40
[SQL][SERVER] SQL Server 資料型別對應
SQL Server 資料型別對應 .NET Framework 4.5 其他版本 SQL Server 和 .NET Framework 是以不同的型別系統為基礎。
例如，.NET Framework Decimal 結構的最大小數點位數為 28，而 SQL Server decimal 和 numeric 資料型別的最大小數點位數為 38。
- Feb 10 Mon 2014 21:50
[SQL][SERVER] Windows Server 2003 SP2 安裝 SQL Server 2008 R2
安裝前先下載 SQL Server。
直接下載 Microsoft SQL Server 2008 R2 RTM – Express with Management Tools，這是包含 Management Tools
- Jan 09 Thu 2014 21:09
[SQL][SERVER] 一次顯示所有資料
- Nov 28 Thu 2013 11:50
[SQL][SERVER] 防止儲存需要資料表重建的變更
- Nov 06 Wed 2013 22:46
[SQL][SERVER] Microsoft SQL Server 200x or R2 解除安裝
- Nov 05 Tue 2013 20:52
[SQL][SERVER] Windows 7 可以安裝哪些版本的 MSSQL Server
Windows 7 嶄新的操作介面，執行速度又比他的兩個哥哥 Windows Vista 跟 Windows XP 來的快，相信有不少人計畫
（或是已經）改用 Windows 7。
汽車、機車 (2)
