SqlServer
zhao8848jun
一个胖胖的小伙子,天天坐在电脑前,从面前的键盘上敲击绘画着自己炫丽的人生
三年高级程序员,专业从事Asp.net网站建设与B/s软件开发
展开
-
在SQL Server2005/2008中对记录进行分组,并获得每组前N条记录
假设有一个表,SQL语句如下:CREATE TABLE [dbo].[scan]( [km] [int] NULL, [kh] [int] NULL, [cj] [int] NULL) ON [PRIMARY] 其中km为科目号、kh为考生号、cj为成绩,现对km和kh进行分组,并获得每组前2条记录(按cj从高到低排序)。基本思想是为每组加一个序号列,再用where取序号小于等于2的。SQL语句如下:select * from ( select a.km,a.kh,cj,row转载 2011-04-08 23:57:00 · 432 阅读 · 0 评论 -
Code First :使用Entity. Framework编程(1)
CHAPTER 1 Welcome to Code First 第一章:欢迎来到Code First (译者注:为方便起见,不再直译Code First) Microsoft's ADO.NET Entity Framework, known widely as EF, introduced out-of-the- box Object Relationa转载 2012-07-01 22:17:20 · 2087 阅读 · 0 评论 -
Code First :使用Entity. Framework编程(2)
Chapter2 Your First Look at Code First 第二章:Code First概览 If you've worked with either the first or second edition of Programming Entity Framework, you may recall the business that was th转载 2012-07-01 22:23:09 · 2127 阅读 · 0 评论 -
Code First :使用Entity. Framework编程(3)
CHAPTER 3 Using Conventions and Configurationsfor Property Attributes 第三章 对属性使用约定和配置 In Chapter 2, you got your first look at some of Code First's conventions and how to override Code转载 2012-07-01 22:11:29 · 4133 阅读 · 0 评论