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

ÇósqlÓï¾ä

×Ö¶Îaa,¹²ÓÐ178¸öÊý¾Ý,ÏÔʾʱÊÇÒ»ÁÐÖ±ÅÅÏÂÀ´µÄ,ÎÒÏëÈÃÕâ178¸öÊý¾Ý,ÿÁÐÖ»ÏÔʾ5¸ö,¶àÁÐÏÔʾÍê,ÈçºÎʵÏÖ?

¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ÒýÓÃ
¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ID-1/5À´·Ö



SQL code:
IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB
IF OBJECT_ID('TEMPDB..#') IS NOT NULL DROP TABLE #
GO
CREATE TABLE TB(VAL VARCHAR(50))
INSERT INTO TB
SELECT 'A' UNION ALL
SELECT 'B' UNION ALL
SELECT 'C' UNION ALL
SELECT 'D' UNION ALL
SELECT 'E' UNION ALL
SELECT 'F' UNION ALL
SELECT 'G' UNION ALL
SELECT 'H' UNION ALL
SELECT 'I' UNION ALL
SELECT 'J' UNION ALL
SELECT 'K' UNION ALL
SELECT 'L' UNION ALL
SELECT 'M' UNION ALL
SELECT 'N'

SELECT IDENTITY(INT,0,1) 'ID',VAL INTO # from TB

SELECT
MAX(CASE WHEN ID%5=0 THEN VAL ELSE NULL END)
,MAX(CASE WHEN ID%5=1 THEN VAL ELSE NULL END)
,MAX(CASE WHEN ID%5=2 THEN VAL ELSE NULL END)
,MAX(CASE WHEN ID%5=3 THEN VAL ELSE NULL END)
,MAX(CASE WHEN ID%5=4 THEN VAL ELSE NULL END)
from #
GROUP BY ID/5

/*
A B C D E
F G H I J
K L M N NULL
*/


SQL code:
create table tb(id int, data int)
insert into tb values(1 , 1)
insert into tb values(2 , 2)
insert into tb values(3


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

ÔõôÁ¬½Ó°²×°Ê±Ã»ÓÐʹÓÃĬÈÏʵÀýµÄSQL Server2000?

A»úÆ÷£¨XP£©£¨10.10.6.65£©ÍêÕûµÄ¼ÆËã»úÃûÊÇ: DZD·þÎñÆ÷

ÎÒ×°ÁËÒ»¸ö¸öÈ˰棺 SQLServer2000,´´½¨ÁËÒ»¸öʵÀýÃûΪ£ºMYINSTANCE

×°ÁË£ºdotNetFx35setup.exe

²¢´òºÃÁËSP4²¹¶¡£ºSQL2000-KB884525-SP ......

ÇóÖúÒ»¾äSQLÓï¾ä

Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float

Êý¾ÝÈçÏ£º

Code      CreateTime          Price
031021 2008-10-17 15:00:1 ......

ÇóÒ»sqlÓï¾ä¡£

±íÖÐÊÇÕâÑù£¬
²¿ÃźŠ   ²¿ÃÅÐÅÏ¢
  1        ²¿ÃÅÒ»
  2        ²¿ÃŶþ
  3        ²¿ÃÅÈý
  4& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ