<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[卢海兵的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sdluhaibing</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sdluhaibing]]></copyright><item><title><![CDATA[.NET Framework 简介]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/5465208</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/5465208</guid><author>sdluhaibing</author><pubDate>Thu, 08 Apr 2010 23:45:00 +0800</pubDate><description><![CDATA[.NET Framework 是支持生成和运行下一代应用程序和 XML Web services 的内部 Windows 组件。.NET Framework 旨在实现下列目标：　　·提供一个一致的面向对象的编程环境，而无论对象代码是在本地存储和执行，还是在本地执行但在 Internet 上分布，或者是在远程执行的。　　·提供一个将软件部署和版本控制冲突最小化的代码执行环境。　　·提供一]]></description><category></category></item><item><title><![CDATA[C#，.net，和Visual Studio]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/5465194</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/5465194</guid><author>sdluhaibing</author><pubDate>Thu, 08 Apr 2010 23:42:00 +0800</pubDate><description><![CDATA[C#是一种编程语言.net Framework是编译环境和运行平台Visual Studio是IDE，程序的开发环境这三者感觉像是分别对应着java、JDK(J2SE,J2EE,J2ME)、Eclipse ]]></description><category></category></item><item><title><![CDATA[GFM TAE runs ]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/5345904</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/5345904</guid><author>sdluhaibing</author><pubDate>Thu, 04 Mar 2010 14:44:00 +0800</pubDate><description><![CDATA[NOTE: This article is specifically about the regular, centralized TAE runs executed for the GFM regional teams on private builds from REGF branches. This article is NOT about the TAE runs executed by ]]></description><category></category></item><item><title><![CDATA[Business Entities Framework]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/5345816</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/5345816</guid><author>sdluhaibing</author><pubDate>Thu, 04 Mar 2010 14:26:00 +0800</pubDate><description><![CDATA[Business Entity Framework OverviewThe Business Entity Framework (BEF) is a test automation library shared by the AX application teamsBEF consists of a list of business entities. A business ent]]></description><category></category></item><item><title><![CDATA[convert date "2009-9-9 22:22:22" to "2009-9-9"]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4915366</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4915366</guid><author>sdluhaibing</author><pubDate>Tue, 01 Dec 2009 16:16:00 +0800</pubDate><description><![CDATA[select   convert(char(10),getdate(),120)]]></description><category></category></item><item><title><![CDATA['union all' two select sentences contain 'order by']]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4470342</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4470342</guid><author>sdluhaibing</author><pubDate>Fri, 21 Aug 2009 15:39:00 +0800</pubDate><description><![CDATA[ declare @prod table (pid int, title varchar(30))insert into @prodselect 1,测试产品1  union allselect 2,测试产品2  union allselect 3,测试产品3  union allselect 4,测试产品4  union allselect 5,]]></description><category></category></item><item><title><![CDATA[example of creating table ]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4469211</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4469211</guid><author>sdluhaibing</author><pubDate>Fri, 21 Aug 2009 11:12:00 +0800</pubDate><description><![CDATA[ declare @tablea table (id int,[type] int,number int,area int,[power] int)insert into @tableaselect 1,1,23,78,98 union allselect 2,2,56,27,67 union allselect 3,3,21,34,23 union allselect 4,4]]></description><category></category></item><item><title><![CDATA[update the type of a field  in many tables one time]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4434771</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4434771</guid><author>sdluhaibing</author><pubDate>Tue, 11 Aug 2009 15:30:00 +0800</pubDate><description><![CDATA[DECLARE @fieldtype sysname SET @fieldtype=varchar --删除处理 DECLARE hCForEach CURSOR GLOBAL FOR SELECT Nupdate +QUOTENAME(o.name)     +N set  + QUOTENAME(c.name) + N = replace( + QU]]></description><category></category></item><item><title><![CDATA[Create table ,datetime field less than today ]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4429506</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4429506</guid><author>sdluhaibing</author><pubDate>Mon, 10 Aug 2009 09:14:00 +0800</pubDate><description><![CDATA[CREATE TABLE tb(    ID INT IDENTITY NOT NULL,    StartDateTime DATETIME,    CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime < GETDATE()));]]></description><category></category></item><item><title><![CDATA[exec procedure every 5mins]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4417158</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4417158</guid><author>sdluhaibing</author><pubDate>Thu, 06 Aug 2009 09:35:00 +0800</pubDate><description><![CDATA[ while 1=1begin  waitfor delay 00:05:00  exec Pinsertend ]]></description><category></category></item><item><title><![CDATA[delete duplicate strings in different records]]></title><link>https://blog.youkuaiyun.com/sdluhaibing/article/details/4411055</link><guid>https://blog.youkuaiyun.com/sdluhaibing/article/details/4411055</guid><author>sdluhaibing</author><pubDate>Wed, 05 Aug 2009 11:01:00 +0800</pubDate><description><![CDATA[ IF OBJECT_ID(tb) IS NOT NULLDROP TABLE tbGOCREATE TABLE tb( a varchar(30))goinsert tb SELECT 001,003,008 UNION ALL SELECT 003,008,019godeclare @s varchar(40)select @s=isnull(@]]></description><category></category></item></channel></rss>