摘要： oracle的安装与plsql的环境配置 1. 首先得有oracle的安装包和plsql的安装包，安装包地址可见百度云 http://pan.baidu.com/s/1miTqhmg 2. 解压，找到set.exe文件，双击安装即可 注意: 安装的时候有两个目录是要自己创建的，否则安装不成功，自己安 阅读全文

摘要： https://www.codeproject.com/Tips/1233146/Working-with-MSDTC 阅读全文

摘要： Step 1 File -> Preferences -> Proxy Settings set to None Step 2 In my case the server were the service was installed was configured only for TLS. SSL 阅读全文

摘要： --Oracle,one owner access another owner's tables,no need pre-owner --相当于alias(别名),比如把fms.US_SEARCH_AUDIT在fms_user中建一个同义词fms --under owner fms_user cre 阅读全文

摘要： //ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls; //.NET 4.5 //.NET 4.6 and above,no any code need add//ServicePointManager.SecurityP 阅读全文

摘要： Client eil_userid = BaseCmConfig.GetCustomSettings("EILUserId"); eil_pw = BaseCmConfig.GetCustomSettings("EILPassword"); eil_pw = FMSEncrypt.Decrypt(e 阅读全文

摘要： 解決方法1. 開啟「開始 / 程式集 / Microsoft Visual Studio 2010 / Visual Studio Tools / Visual Studio Command Prompt」 2. 輸入「devenv.exe /resetskippkgs」 3. 開啟之前未能開啟的專 阅读全文

摘要： https://social.msdn.microsoft.com/Forums/en-US/4ea808e7-c503-4f99-9480-aa8e6938be3d/net-framework-35-doesnt-install-windows-10-error-code-0x800f081f?f 阅读全文

摘要： IF DB_ID('Wages') IS NOT NULLDROP DATABASE WagesGOcreate database Wages if OBJECT_ID('StudentInfo','U') IS NOT NULL DROP TABLE StudentInfoGO CREATE TA 阅读全文

摘要： ALTER TABLE表名ALTER column 列名 varchar(35) NULL EXEC SP_RENAME 'TABLE.[old-column-name]','new-column-name' EXEC sp_rename 'old-table-name', 'new-table-n 阅读全文