Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL ÐÐÁл¥×ª

--ÐÐÁл¥×ª
/******************************************************************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶®
ÕûÀíÈË£ºÖйú·ç(Roy)
ÈÕÆÚ:2008.06.06
******************************************************************************************************************************************************/
--1¡¢Ðл¥ÁÐ
--> --> (Roy)Éú³É測試數據
if not object_id('Class') is null
    drop table Class
Go
Create table Class([Student] nvarchar(2),[Course] nvarchar(2),[Score] int)
Insert Class
select N'ÕÅÈý',N'ÓïÎÄ',78 union all
select N'ÕÅÈý',N'Êýѧ',87 union all
select N'ÕÅÈý',N'Ó¢Óï',82 union all
select N'ÕÅÈý',N'ÎïÀí',90 union all
select N'ÀîËÄ',N'ÓïÎÄ',65 union all
select N'ÀîËÄ',N'Êýѧ',77 union all
select N'ÀîËÄ',N'Ó¢Óï',65 union all
select N'ÀîËÄ',N'ÎïÀí',85
Go
--2000·½·¨:
¶¯Ì¬:
declare @s nvarchar(4000)
set @s=''
Select     @s=@s+','+quotename([Course])+'=max(case when [Course]='+quotename([Course],'''')+' then [Score] else 0 end)'
from Class group by[Course]
exec('select [Student]'+@s+' from Class group by [Student]')
Éú³É¾²Ì¬:
select
    [Student],
    [Êýѧ]=max(case when [Course]='Êýѧ' then [Score] else 0 end),
    [ÎïÀí]=max(case when [Course]='ÎïÀí' then [Score] else 0 end),
    [Ó¢Óï]=max(case when [Course]='Ó¢Óï' then [Score] else 0 end),
    [ÓïÎÄ]=max(case when [Course]='ÓïÎÄ' then [Score] else 0 end)
from
    Class
group by [Student]
GO
¶¯Ì¬:
declare @s nvarchar(4000)
Select     @s=isnull(@s+',','')+quotename([Course]) from Class group by[Course]
exec('select * from Class pivot (max([Score]) for [Course] in('+@s+'))b')
Éú³É¾²Ì¬:
select *
from
    Class
pivot
    (max([Score]) for [Course] in([Êýѧ],[ÎïÀí],[Ó¢Óï],[ÓïÎÄ]))b


Ïà¹ØÎĵµ£º

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......

SQL Server 2005 Óë SQL Express µÄÒìͬ


SQL Server Express 2005£¨ÒÔϼò³Æ SQLExpress£© ÊÇÓÉ΢Èí¹«Ë¾¿ª·¢µÄ SQL Server 2005£¨ÒÔϼò³Æ SQL2005£©µÄËõ¼õ°æ£¬Õâ¸ö°æ±¾ÊÇÃâ·ÑµÄ£¬Ëü¼Ì³ÐÁË SQL Server 2005 µÄ¶àÊý¹¦ÄÜÓëÌØÐÔ£¬È磺°²È«ÐÔÉèÖá¢×Ô¶¨Ò庯ÊýºÍ¹ý³Ì¡¢Transact-SQL¡¢SQL¡¢CLR µÈ£¬»¹Ãâ·ÑÌṩÁ˺ÍËüÅäÌ׵ĹÜÀíÈí¼þ SQL Server Management Studio Expre ......

sqlµ¼³öÊý¾Ý¿âʱ±¨ "µÇ½ xxx ʧ°Ü",ÎÞ·¨Íê³É

sqlµ¼³öÊý¾Ý¿âʱ±¨ "µÇ½ xxx ʧ°Ü",ÎÞ·¨Íê³É
µ¼³öÊý¾Ý¿âʱʧ°Ü,µã»÷ÏëÏëÐÅϢʱÏÔʾ:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]µÇ½ xxx ʧ°Ü
ÒòÊý¾Ý¿âÊÇÖ±½ÓÒûÓÃËûÈ˵Ä,Ìí¼Ó¶ø³É,Òò´Ë²»È·¶¨ xxx µ½µ×ÊÇʲô,Ö»ºÃ½«Ïà¹ØÏîÒÀ´Îɾ³ý
½«Í¬Ãû xxx ±íɾ³ý,ɾ³ýÏà¹ØÊÓͼ,ÖØÊÔ,²»ÐÐ.
ɾ³ýÈ«²¿ÊÓͼ,²»ÐÐ.
żȻ ......

sql serverÖеĴ洢¹ý³Ìµ÷ÊÔ

µ÷ÊÔ:
ÔÚSQL QUERYÖЗ¡·¶ÔÏóä¯ÀÀÆ÷—¡·´æ´¢¹ý³Ì—¡·Ñ¡ÔñÒªµ÷ÊԵĴ洢¹ý³Ì—¡·ÓÒ»÷—¡·Ñ¡Ôñµ÷ÊÔ£¨debug£©—¡·ÊäÈë²ÎÊý—¡·--ÉèÖÃÍêÄãµÄ²ÎÊýÖµºó--µã»÷Ö´ÐУ¬¾ÍÊdzöÏÖÒ»¸ö¸¡¶¯¹¤¾ßÌõ£¬ÉÏÃæÓе¥²½Ö´ÐУ¬¶ÏµãÉèÖõÈ
---¸ú×Ù :
¿ªÊ¼->³ÌÐò->MS SQLSERVER->ʼþ̽²éÆ÷(SQL Prof ......

SQL ÖÐÎÄתƴÒô


--º¯ÊýÈçÏ£º
/*
CREATE FUNCTION dbo.fnpbGetPYFirstLetter 

@str NVARCHAR(4000) 

RETURNS NVARCHAR(4000) 
--WITH ENCRYPTION 
AS 
BEGIN 
DECLARE @WORD NCHAR(1),@PY NVARCHAR(4000)
SET @PY=''
WHILE LEN(@STR)>0 
BEGIN 
SET @WORD=LEF ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ