- 博客(11)
- 资源 (1)
- 收藏
- 关注
原创 .NET Framework 简介
.NET Framework 是支持生成和运行下一代应用程序和 XML Web services 的内部 Windows 组件。.NET Framework 旨在实现下列目标: ·提供一个一致的面向对象的编程环境,而无论对象代码是在本地存储和执行,还是在本地执行但在 Internet 上分布,或者是在远程执行的。 ·提供一个将软件部署和版本控制冲突最小化的代码执行环境。 ·提供一
2010-04-08 23:45:00
511
原创 C#,.net,和Visual Studio
C#是一种编程语言.net Framework是编译环境和运行平台Visual Studio是IDE,程序的开发环境这三者感觉像是分别对应着java、JDK(J2SE,J2EE,J2ME)、Eclipse
2010-04-08 23:42:00
393
原创 GFM TAE runs
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
2010-03-04 14:44:00
541
原创 Business Entities Framework
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
2010-03-04 14:26:00
979
原创 convert date "2009-9-9 22:22:22" to "2009-9-9"
select convert(char(10),getdate(),120)
2009-12-01 16:16:00
557
原创 'union all' two select sentences contain 'order by'
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,
2009-08-21 15:39:00
351
原创 example of creating table
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
2009-08-21 11:12:00
324
原创 update the type of a field in many tables one time
DECLARE @fieldtype sysname SET @fieldtype=varchar --删除处理 DECLARE hCForEach CURSOR GLOBAL FOR SELECT Nupdate +QUOTENAME(o.name) +N set + QUOTENAME(c.name) + N = replace( + QU
2009-08-11 15:30:00
301
原创 Create table ,datetime field less than today
CREATE TABLE tb( ID INT IDENTITY NOT NULL, StartDateTime DATETIME, CONSTRAINT CHK_CONS_STARTDATETIME CHECK(StartDateTime < GETDATE()));
2009-08-10 09:14:00
387
原创 exec procedure every 5mins
while 1=1begin waitfor delay 00:05:00 exec Pinsertend
2009-08-06 09:35:00
433
原创 delete duplicate strings in different records
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(@
2009-08-05 11:01:00
370
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人
RSS订阅