hank

https://support.microsoft.com/zh-tw/kb/918992 COPY以下程式碼在舊的SQL SERVER上執行，執行完後會產生2支 預存程序： sp_hexadecimal  預存程序和  sp_help_revlogin  預存程序 USE master GO IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT AS DECLARE @charvalue varchar (514) DECLARE @i int DECLARE @length int DECLARE @hexstring char(16) SELECT @charvalue = '0x' SELECT @i = 1 SELECT @length = DATALENGTH (@binvalue) SELECT @hexstring = '0123456789ABCDEF' WHILE (@i <= @length) BEGIN DECLARE @tempint int DECLARE @firstint int DECLARE @secondint int SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1)) SELECT @firstint = FLOOR(@tempint/16) SELECT @secondint = @tempint - (@firstint*16) SELECT @charvalue = @charvalue + SUBSTRING(@hexstring, @firstint+1, 1) + SUBSTRING(@hexstring, @secondint+1, 1) SELECT @i = @i + 1 END SELECT @hexvalue = @charvalue GO IF OBJECT_ID ('sp_help_re

參考:https://dotblogs.com.tw/supershowwei/2016/02/02/112238 1.安裝相關工具 net-tools wget gcc tcl yum -y install net-tools wget gcc tcl 2.下載及解壓縮 Redis cd ~ wget http://download.redis.io/releases/redis- 3.0 . 7 .tar.gz tar xzf redis- 3.0 . 7 .tar.gz 3.編譯 Redis cd redis- 3.0 . 7 make 4.測試及安裝 Redis make test make install 5.建立相關目錄 mkdir /etc/redis mkdir /var/redis 6.複製設定檔 cp ~/redis- 3.0 . 7 /redis.conf /etc/redis/redis_6379.conf 7.建立工作目錄 mkdir /var/redis/ 6379 8.修改 Redis 參數值 vi /etc/redis/redis_6379.conf 將 daemonize 的值修改為  yes 將 pidfile 的值修改為  /var/run/redis_6379.pid 將 logfile 的值修改為  /var/log/redis_6379.log 將 dir 的值修改為  /var/redis/6379 9.開啟防火牆 6379 埠號 firewall-cmd --permanent --add-port= 6379 /tcp firewall-cmd --reload 10.設定 Redis 在開機時就啟動 建立 Redis 服務設定檔 vi /lib/systemd/system/redis_6379.service 將下面的內容貼到檔案裡面，儲存並且離開。 [Unit] Description =Redis on port 6379 After =network.target [Service] Type =forking ExecStart =/usr/local/bin/redis-ser