Mon, 27 Oct 2008 06:17:00 GMThttp://blog.csdn.net/lihonggen0/http://blog.csdn.net/lihonggen0/archive/2008/10/27/3155846.aspxhttp://blog.csdn.net/lihonggen0/comments/3155846.aspx0http://blog.csdn.net/lihonggen0/comments/commentRss/3155846.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3155846以前发了一个比较两个数据库表结构差异的SQL，现在有一个开源项目　http://www.codeplex.com/OpenDBiff　　做这件事情，附件是OpenDBDiff的可执行文件。一些软件公司也开发过类似的工具，如DB Explorer，SQLDBCompare来进行数据库比较和同步。现在，微软加了这个Feature在VS2008里（写工具的遇到挑战了），如果你装了微软的VS2008，就可以进行比较，同步。<img src ="http://blog.csdn.net/lihonggen0/aggbug/3155846.aspx" width = "1" height = "1" />Mon, 27 Oct 2008 14:17:00 +0800李洪根http://blog.csdn.net/lihonggen0/archive/2008/10/27/3155846.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2008/10/27/3155846.aspx李洪根http://blog.csdn.net/lihonggen0/archive/2008/10/27/3155755.aspxhttp://blog.csdn.net/lihonggen0/comments/3155755.aspx0http://blog.csdn.net/lihonggen0/comments/commentRss/3155755.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=3155755<br />其实很简单，相对于SQL 2000改了sys.all_objects和sys.columns<br /><br />declare @tblname varchar(200)<br />declare @object_id   int<br />declare tbl_cursor CURSORfor<br />select name,object_idfromsys.all_objectswheretype='u'<br /><br />open tbl_cursor<br /><br />FETCHNEXTFROM tbl_cursor <br />INTO @tblname,@object_id<br /><br />while@@FETCH_STATUS= 0<br />Begin<br /><br />    declare @str varchar(8000)<br />    declare @selectstr varchar(2000)<br />    set @selectstr=''<br />    set @str='INSERT IN<img src ="http://blog.csdn.net/lihonggen0/aggbug/3155755.aspx" width = "1" height = "1" />Mon, 27 Oct 2008 13:59:00 +0800李洪根http://blog.csdn.net/lihonggen0/archive/2008/10/27/3155755.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2008/10/27/3155755.aspx李洪根http://blog.csdn.net/lihonggen0/archive/2007/12/11/1929673.aspxhttp://blog.csdn.net/lihonggen0/comments/1929673.aspx7http://blog.csdn.net/lihonggen0/comments/commentRss/1929673.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1929673IT调研服务提供商IDC日前发布的一份调研报告指出，中国38％的IT从业人员靠微软及其合作伙伴所组成的生态系统生存。而无论是产品的版本升级还是不断出新，微软迈在技术前沿的脚步向来矫健。 微软系技术的开发者如何从中把握技术方向、如何选择并面对面对不断出现的新技术……带着诸多问题，记者采访了2003-2007微软最有价值专家，TechExcel中国研发部经理李洪根。 <img src ="http://blog.csdn.net/lihonggen0/aggbug/1929673.aspx" width = "1" height = "1" />Wed, 12 Dec 2007 00:23:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2007/12/11/1929673.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2007/12/11/1929673.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2006/02/23/607013.aspxhttp://blog.csdn.net/lihonggen0/comments/607013.aspx1http://blog.csdn.net/lihonggen0/comments/commentRss/607013.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=607013You can use Device Emulator Manager for the purpose. 1. In activesync File->Connection Settings-> "Allow Connections to one of the following"->select DMA from combo-box. <img src ="http://blog.csdn.net/lihonggen0/aggbug/607013.aspx" width = "1" height = "1" />Thu, 23 Feb 2006 19:37:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2006/02/23/607013.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2006/02/23/607013.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/11/13/180394.aspxhttp://blog.csdn.net/lihonggen0/comments/180394.aspx9http://blog.csdn.net/lihonggen0/comments/commentRss/180394.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=180394在VB6和VB.NET中进行图象捕获<img src ="http://blog.csdn.net/lihonggen0/aggbug/180394.aspx" width = "1" height = "1" />Sun, 14 Nov 2004 00:37:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/11/13/180394.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2004/11/13/180394.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/11/01/162402.aspxhttp://blog.csdn.net/lihonggen0/comments/162402.aspx2http://blog.csdn.net/lihonggen0/comments/commentRss/162402.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=162402关于Asp.net中Cookie的问题，如中文乱码、Remove清除的问题。<img src ="http://blog.csdn.net/lihonggen0/aggbug/162402.aspx" width = "1" height = "1" />Tue, 02 Nov 2004 00:39:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/11/01/162402.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2004/11/01/162402.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/10/16/139307.aspxhttp://blog.csdn.net/lihonggen0/comments/139307.aspx2http://blog.csdn.net/lihonggen0/comments/commentRss/139307.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=139307SQL Server 2005安装及界面截图，新增功能．<img src ="http://blog.csdn.net/lihonggen0/aggbug/139307.aspx" width = "1" height = "1" />Sun, 17 Oct 2004 05:46:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/10/16/139307.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2004/10/16/139307.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/09/26/117299.aspxhttp://blog.csdn.net/lihonggen0/comments/117299.aspx0http://blog.csdn.net/lihonggen0/comments/commentRss/117299.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=117299我给微软中国研发中心开发工具国际化部谭强的信，关于Visual Studio .NET 2005<img src ="http://blog.csdn.net/lihonggen0/aggbug/117299.aspx" width = "1" height = "1" />Sun, 26 Sep 2004 23:12:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/09/26/117299.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2004/09/26/117299.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/09/25/116708.aspxhttp://blog.csdn.net/lihonggen0/comments/116708.aspx7http://blog.csdn.net/lihonggen0/comments/commentRss/116708.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=116708整理机器时发现，偶在2001-2003年CSDN论坛VB版参与的一些贴子！特此放上来！ <img src ="http://blog.csdn.net/lihonggen0/aggbug/116708.aspx" width = "1" height = "1" />Sun, 26 Sep 2004 00:48:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/09/25/116708.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2004/09/25/116708.aspxlihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/09/24/115383.aspxhttp://blog.csdn.net/lihonggen0/comments/115383.aspx0http://blog.csdn.net/lihonggen0/comments/commentRss/115383.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=115383在VB6和VB.NET中获取和设置光标的位置，设置光标的形状，显示和隐藏光标。 很简单的东西，更多的实例，可以参考API手册和Framework的文档。 <img src ="http://blog.csdn.net/lihonggen0/aggbug/115383.aspx" width = "1" height = "1" />Fri, 24 Sep 2004 20:43:00 +0800lihonggenhttp://blog.csdn.net/lihonggen0/archive/2004/09/24/115383.aspx#Feedbackhttp://blog.csdn.net/lihonggen0/archive/2004/09/24/115383.aspxlihonggen