SQLServer Case when中文乱码
正常写如下select MAINACCOUNTID,NAME,CURRENCYCODE,CONSOLIDATIONMAINACCOUNT, case EXCHANGEAD...
教程
76 篇文章
无法将数据库从SINGLE_USER模式切换回MULTI_USER模式（Error 5064）
报错信息如下：Msg 5064, Level 16, State 1, Line 1Changes to the state or options of database 'test&...
SQL Server 部分函数使用
SQL Server 或取上月当月始末日期--本月第一天： select dateadd(dd,-day(getdate( +1,getdate( --本月最...
win10的L2TP连接失败，报远程服务器未响应
...
Git中.gitignore 不起作用问题的解决
如果某些文件已经被纳入了版本管理中，就算是在.gitignore中已经声明了忽略路径也是不起作用的，这时候我们就应该先把本地缓存删除，然后再进行git的push，这样就不会出现忽略的文件了。g...
SSIS配置部署包
1、转package deployment model2、配置生成地址和是否生成部署程序3、更改Run64BitRuntime FALSE避免后续会报错4、更改Protectionlevel...
![[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED](http://maryd.cn/thuimg/thumb-75-260-260.jpg "[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED")
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on...
![[SSIS.Pipeline] Error: "ODBC Source" failed validation and returned validation status "VS_NEEDSNEWME](http://maryd.cn/thuimg/thumb-74-260-260.jpg "[SSIS.Pipeline] Error: \"ODBC Source\" failed validation and returned validation status \"VS_NEEDSNEWME")
[SSIS.Pipeline] Error: "ODBC Source" failed validation and returned validation status "VS_NEEDSNEWME
SSRS数据源报错[SSIS.Pipeline] Error: "ODBC Source" failed validation and returned validatio...
SSIS ODBC方式连接mysql数据库
...
AX2012 Cannot create a record in SysXppAssembly (SysXppAssembly). The record already exists.
I have done some changes in one class. That class is running on the server side. It is related t...