Trending Up...

原创 Configure SQL Server 2005 to allow remote connections

 http://support.microsoft.com/default.aspx?scid=kb;EN-US;9142771) Enable "Allow Remote Connection" in SQL Server Surface Area Configuration2) Enable and start SQL Browser service3) Enable TCP/IP

转载 图解eclipse+myelcipse开发EJB[ZZ] + My Deployment

在开发ejb之前，我们先得配置好服务器，我使用的是Weblogic9.0中文版，关于Weblogic9.0配置请看我的另一片文章。配置Weblogic9.0        首先需要配置好eclipse。我这里主要说明weblogic的配置。         注意JDK选择JDK5.0的版本。        顺便将weblogic8的配置也贴上来，供大家比较参考            注意weblo

原创 Change version information and icon of console applications

1)Change Version InfoAdd {$ *.RES} by hand to the .dpr and Version info information can then be manipulated2)Change ICONDelphi icon can be easily changed, fool the .DPR parser with "application.

原创 Add thousand separator (SQL Server 2005)

-- seq table: 1,2,3,4,5....declare @s varchar(100)set @s = 3470040796print @sselect reverse((select substring(reverse(@s), [id], 1) + case when [id] % 3 = 0 then , else end + from seqwher

原创 Shrink SQL Server Log Files

--sql server 2005use SampleDBGODECLARE @DBName NVARCHAR(100)SET @DBName = DB_NAME()EXEC(BACKUP LOG [ + @DBName + ] WITH TRUNCATE_ONLY)GOSELECT [id]=ROW_NUMBER() OVER (ORDER BY [file_id]), [n

转载 Delphi DataSet Architecture vs ADO.Net [ZZ]