¡¾×ª¡¿ sqlͳ¼Æ£¹ØÓÚѧÉú³É¼¨
sqlͳ¼Æ£¹ØÓÚѧÉú³É¼¨
http://blog.sina.com.cn/s/blog_61380b320100ej9k.html
sqlͳ¼Æ£¹ØÓÚѧÉú³É¼¨
ѧÉú³É¼¨±í(stuscore)£º
ÐÕÃû£ºname
¿Î³Ì£ºsubject
·ÖÊý£ºscore
ѧºÅ£ºstuid
ÕÅÈý
Êýѧ
89
1
ÕÅÈý
ÓïÎÄ
80
1
ÕÅÈý
Ó¢Óï
70
1
ÀîËÄ
Êýѧ
90
2
ÀîËÄ
ÓïÎÄ
70
2
ÀîËÄ
Ó¢Óï
80
2
´´½¨±í
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[stuscore](
[name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[subject] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[score] [int] NULL,
[stuid] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
ÎÊÌ⣺
1. ¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû(ÒªÇóÏÔʾ×ֶΣºÐÕÃû£¬×ܳɼ¨)
2. ¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû(ÒªÇóÏÔʾ×Ö¶Î: ѧºÅ£¬ÐÕÃû£¬×ܳɼ¨)
3. ¼ÆËãÿ¸öÈ˵¥¿ÆµÄ×î¸ß³É¼¨(ÒªÇóÏÔʾ×Ö¶Î: ѧºÅ£¬ÐÕÃû£¬¿Î³Ì£¬×î¸ß³É¼¨)
4. ¼ÆËãÿ¸öÈ˵Äƽ¾ù³É¼¨£¨ÒªÇóÏÔʾ×Ö¶Î: ѧºÅ£¬ÐÕÃû£¬Æ½¾ù³É¼¨£©
5. Áгö¸÷Ãſγ̳ɼ¨×îºÃµÄѧÉú(ÒªÇóÏÔʾ×Ö¶Î: ѧºÅ£¬ÐÕÃû,¿ÆÄ¿£¬³É¼¨)
6. Áгö¸÷Ãſγ̳ɼ¨×îºÃµÄÁ½Î»Ñ§Éú(ÒªÇóÏÔʾ×Ö¶Î: ѧºÅ£¬ÐÕÃû,¿ÆÄ¿£¬³É¼¨)
7. ͳ¼ÆÈçÏ£º
ѧºÅ
ÐÕÃû
ÓïÎÄ
Êýѧ
Ó¢Óï
×Ü·Ö
ƽ¾ù·Ö
8£®Áгö¸÷Ãſγ̵Äƽ¾ù³É¼¨£¨ÒªÇóÏÔʾ×ֶΣº¿Î³Ì£¬Æ½¾ù³É¼¨£©
9£®ÁгöÊýѧ³É¼¨µÄÅÅÃû£¨ÒªÇóÏÔʾ×ֶΣºÑ§ºÅ£¬ÐÕÃû£¬³É¼¨£¬ÅÅÃû£©
10£®ÁгöÊýѧ³É¼¨ÔÚ2-3ÃûµÄѧÉú£¨ÒªÇóÏÔʾ×ֶΣºÑ§ºÅ£¬ÐÕÃû,¿ÆÄ¿£¬³É¼¨£©
11£®Çó³öÀîËĵÄÊýѧ³É¼¨µÄÅÅÃû
12£®Í³¼ÆÈçÏ£º
¿Î³Ì
²»¼°¸ñ£¨0-59£©¸ö
Á¼£¨60-80£©¸ö
ÓÅ£¨81-100£©¸ö
13£®Í³¼ÆÈçÏ£ºÊýѧ:ÕÅÈý(50·Ö),ÀîËÄ(90·Ö),ÍõÎå(90·Ö),ÕÔÁù(76·Ö)
Ïà¹ØÎĵµ£º
1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óÐ ......
ÓÐÖ´ÐÐsqlÌõ¼þÓï¾äwhere id in(@²ÎÊý)µÄʱºò£¬Èç¹û´¦Àí²»µ±£¬¾Í»á³öÏÖÎÊÌ⣺
ÈçÏÂÃæÕâ¸ö´æ´¢¹ý³Ì£º
alter proc Web_gettwtwgoldgameserverGoldSell
@ID int
as
declare @twgoldsellID nvarchar(1000)
select @twgoldsellID=twgoldsellID from twgoldgameserver where ID=@ID
set @twgoldsellID=replace(@twgoldsell ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient; //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
/*******************************************************************************
&n ......
SQL SERVER 2008 ¸ü¸Ä¸ú×Ù
/*
¿´Ê飬¿´Áª»úÆڼ䡣¡£¡£Ë³´ø°Ñ¿´µ½µÄдÏÂ
ÓëSQL SERVER 2008 CDC Òì²½²¶»ñÊý¾Ý±ä¸üµÄ²»Í¬,¸ü¸Ä¸ú×ÙÊÇͬ²½½ø³Ì,
ÊÇDML(INSERT/UPDATE/DELETE)ÊÂÎñµÄÒ»²¿·Ö,Ëü¿ÉÒÔʹÓÃ×îСµÄCÅÌ´æ´¢
¿ªÏúÀ´Õì²âÊý¾ÝÐеľ»±ä¸ü.ÄÇôËüÒ²¾Í²»ÄÜÏñCDCÄÇÑù¿ÉÒÔÌṩÓû§±íµÄ
ÀúÊ·¸ü¸ÄÐÅÏ¢. ¸ü¸ÄÊÇʹÓÃÒ ......
Sqlʱ¼äº¯Êý
Ò»¡¢sql serverÈÕÆÚʱ¼äº¯Êý
Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
Àý ......