摘要:
一、系统描述源系统:Windows Server 2003 Standard Edition SP2SQL Server 2005 Standard Edition目标系统:Windows Server 2003 Standard Edition SP2SQL Server 2008 Standard Edition二、备份原SQL Server 20051, 备份数据库文件:ReportServer和ReportServerTempDB2, 备份Encryption keys具体操作:1, 备份数据库采用全(Full)备份分别备份ReportServer和ReportServerTempDB 阅读全文
阅读排行榜
Executing a stored procedure with an output parameter using Entity Framework
2011-03-02 10:43 by @GB, 595 阅读, 收藏,
摘要:
var p_usr = new SqlParameter { ParameterName = "@usr", Value = user };var p_suc = new SqlParameter { ParameterName = "@suc", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int };context.ExecuteStoreCommand("exec sp_User_Delete @usr,@suc output", p_usr, p_s 阅读全文
Ubuntu - Discuz X3.1 伪静态
2014-04-26 21:54 by @GB, 541 阅读, 收藏,
摘要:
1. .htaccess放到网站根目录RewriteEngine OnRewriteBase /RewriteCond %{QUERY_STRING} ^(.*)$RewriteRule ^topic-(.+)\.html$ portal.php?mod=topic&topic=$1&%1Rewri... 阅读全文
Dynamics CRM for Outlook问题集
2014-03-30 11:33 by @GB, 504 阅读, 收藏,
摘要:
1. CRM for Outlook不能连接CRM Server错误:System.ServiceModel.Security.SecurityNegotiationException: The caller was not authenticated by the service23:15:24| Error| Error connecting to URL: http://dev-crm/XRMServices/2011/Discovery.svc Exception: System.ServiceModel.Security.SecurityNegotiationException: . 阅读全文
利用Oracle.DataAccess调用Function的遇到的一个诡异问题
2012-01-18 14:21 by @GB, 485 阅读, 收藏,
摘要:
这是一段很简单的Function,(随便举个例子)FUNCTIONExecute(message_id_INOUTNUMBER, part_no_INOUTVARCHAR2)RETURNVARCHAR2ISBEGIN //这里,接收message_id_参数,做某些处理part_no_:='123456';RETURN'test';ENDExecute;以前是采用微软不再支持的System.Data.OracleClient命名空间,如下:varconnectionString="xxxx";OracleConnectionconn=newO 阅读全文