摘要： 本人今天使用visual studio 2010 打开silverlight project时候，突然项目加载失败，报的错误信息居然是没有安装silverlight developer runtime。气死我了，我已经安装了呀，百般查找，终于找到了答案，将网址和内容张贴如下http://forums.silverlight.net/t/235905.aspx/1解决办法：Reinstall the current Silverlight Runtime and Silverlight Tools for Visual Studio 2010. This will resolve the is. 阅读全文

摘要： IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Audit') CREATE TABLE LogTable ( LogID [int]IDENTITY(1,1) NOT NULL, Type char(1), TableName varchar(128), PrimaryKeyField varchar(1000), PrimaryKeyValue varchar(1000), FieldName varchar(128), OldValue varchar(1000), NewV 阅读全文

摘要： table sturcture {taskRecordId,taskDate,userId,teamId,taskId,unit,nots}delete duplicate taskDate,UserId,teamId and taskId.the sql isdelete from TaskRecordselect * from TaskRecordwhere taskRecordId in (select MIN(taskRecordId) from TaskRecord t join(select COUNT(*) d,taskDate,userId,teamId from TaskR. 阅读全文

摘要： Have you ever needed to set up Analysis Services in a multidomain network environment? Have you needed to provide access to your Analysis Services server through a firewall? If so, you probably needed to choose an alternative security configuration. By default, Analysis Services uses integrated ... 阅读全文

摘要： 引自：http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspxIn this article I will show you how to set up an SQL server that provides. 阅读全文

摘要： 最近项目中需要处理递归，于是想到使用CTE，可是不是很熟悉，google一番后发现了下面这篇精彩的文章， 虽然是针对DB2的CTE，但我想MSSQL应该同理，现美文如下http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-1010liush/index.html 转自: 递归 SQL 在 DB2 中通过公共表表达式 (CTE，Common Table Expression) 来实现。递归 SQL 由递归 CTE 以及对递归 CTE 结果的查询组成。那什么是递归 CTE 呢？简言之，如果 CTE 中的... 阅读全文

摘要： 引自：http://www.cnblogs.com/7788/archive/2009/05/13/1455920.html string.Format字符串格式化说明 先举几个简单的应用案例： 1、格式化货币（跟系统的环境有关，中文系统默认格式化人民币，英文系统格式化美元） string.Format("{0:C}",0.2) 结果为：￥0.20 （英文操作系统结果：$0.20） 默认格式化小数点后面保留两位小数，如果需要保留一位或者更多，可以指定位数 string.Format("{0:C1}",23.15) 结果为：￥23.2 （截取会自动四舍五入 阅读全文

摘要： 引自：http://www.4guysfromrolla.com/webtech/042606-1.shtmlIntroductionIt is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a sto. 阅读全文

摘要： after learning to Configure HTTP Access to SQL Server Analysis Services on windows server 2003 ,i will continue how to Configure HTTP Access to SQL Server Analysis Services on IIS 7.0引自：http://msdn.microsoft.com/en-us/library/gg492140.aspx You can enable HTTP access to Analysis Services by configur. 阅读全文

摘要： 引自：http://technet.microsoft.com/en-us/library/cc917711.aspx Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 Published: August 23, 2005 By Edward Melomed Summary:This paper is intended for anyone who is interested in providing access to SQL Server 2005 A. 阅读全文