SQL Server – Rex's Personal Site

將MSSQL DB中的Big5轉UTF-8

利用Notepad++ 編碼 -> 字元集 -> 西歐語系 -> Windows - 1252 -> 貼上DB複製的big5文字 -> 編碼 -> 編譯成UTF-8

https://www.youtube.com/watch?v=HK1FRLisMSQ

Install Microsoft Access Database Engine 2010 Redistributable Install 2007 Office system 驅動程式：資料連線元件 Reference: htt

Codeigniter won't prepend "N" to strings and that's critical for SQL server to retrieve string values. The solution is to revise DB driver of CI: F

Don't use "IN" anymore! Solution: EXISTS http://beyondrelational.com/modules/2/blogs/77/posts/11302/t-sql-worst-practices-a-compilation-from-jac

Key: Use Regular Express Use Instr function Example: SELECT * FROM current_table AS a INNER JOIN new_tabl

(on source server...) BACKUP DATABASE Northwind TO DISK = 'c:\Northwind.bak' (target server...) RESTORE FILELISTONLY FROM DISK =

Install PHP: 5.3 is recommended. (All .dll files related to 5.4 won't work!) http://www.php.net/downloads.php Download Microsoft Drivers: Do

MS SQL: USE [lab] GO /****** Object: Table [dbo].[Employee] Script Date: 12/17/2013 23:15:52 ******/ SET ANSI_NULLS ON GO SET Q