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

ÎÒÏëÓÃÒ»ÌõSQLÏÔʾÕâÑùµÄ½á¹û

²»ÖªµÀÕâÑùµÄÒªÇóÄܲ»ÄÜʵÏÖ£¿
±ÈÈçÎÒÓÐÒ»ÕűíT1£¬ÀïÃæÖ»ÓÐÒ»¸ö×Ö¶Î1
ÀïÃæÓÐ100Ìõ¼Ç¼£¬ÈçÏÂËùʾ£º
×Ö¶Î1
A1
A2
A3
A4
...
A100
ÎÒÏëÓÃÒ»ÌõSQLÏÔʾÕâÑùµÄ½á¹û
µÚÒ»ÁР   µÚ¶þÁР   ...        µÚÊ®ÁÐ
A1        A11                  A91
A2        A12                  A92
A3        A13                  A93
...        ...                  ...
A10        A20                  A100
²»Öª¿É·ñʵÏÖ£¿µ±È»£¬Ò²²»Ò»¶¨·Ö³ÉÊ®ÁУ¬¿ÉÄÜÊÇÎåÁеȵȣ¬Çë¸ßÊִͽ̡£Ð»Ð»
--¼ÙÉè×ֶβ»´æÔÚÏàֵͬ.
select
  max(case (px - 1) % 10 when 0 then ×Ö¶Î1 else '' end) [c1],
  max(case (px - 1) % 10 when 1 then ×Ö¶Î1 else '' end) [c2],
  max(case (px - 1) % 10 when 2 then ×Ö¶Î1 else '' end) [c3],
  max(case (px - 1) % 10 when 3 then ×Ö¶Î1 else '' end) [c4],
  max(case (px - 1) % 10 when 4 then ×Ö¶Î1 else '' end) [c5],
  max(case (px - 1) % 10 when 5 then ×Ö¶Î1 else '' end) [c6],
  max(case (px - 1) % 10 when 6 then ×Ö¶Î1 else '' end) [c7],
  max(case (px - 1) % 10 when 7 then ×Ö¶Î1 else '' end) [c8],
  max(case (px - 1) % 10 when 8 then ×Ö¶Î1 else '' end) [c9],
  max(case (px - 1) % 10 when 9 then ×Ö¶Î1 else '' end) [c10]
from
(
  select * , px = (select count(1) from t1 where ×Ö¶Î1 < t.×Ö¶Î1) + 1 from t1 t
) m
group by (px - 1) / 10
--Èç¹û×ֶδæÔÚÏàֵͬ.
--sql 2000ÐèҪʹÓÃÁÙʱ±í
select * , px = identity(int,1,1) into tmp from t1
select
  max(case (px - 1) % 10 when 0 then ×Ö¶Î1 else '' end) [c1],
  max(case (px - 1) % 10 when 1 then ×Ö¶Î1 else '' end) [c2],
  max(case (px - 1) % 10 when 2 then ×Ö¶Î1 else '' end) [c3],
  m


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

OracleÊý¾Ý¿âSQL*plus³£ÓõÄÃüÁîºÍº¯Êý

 
OracleÖг£ÓõÄÃüÁîºÍº¯Êý£¬×ö¸öÕûÀí£¬ÒÔ±¸ÒÔºóÓõ½£¬·½±ã²éÔÄ¡£
 
³£ÓÃÃüÁ
 
Á¬½Ósqlplus
 
ÃüÁîÐÐÏÂÔËÐÐcmd½øÈ룬ÈçÒÔsysģʽµÇ½£¬ÃüÁîÈçÏ£º
 
(1).sqlplus "sys/zhb126 as sysdba"
 
(2).sqlplus/nolog connect sys/zhb126 as sysdba
 
(3).sqlplus scott ......

PHPµÄ±àдSQLÓï¾äʱ¶ÔÐèҪתÒå×Ö·ûµÄ´¦Àí

1. ¶ÔÓÚPHP magic_quotes_gpc=onµÄÇé¿ö£¬ ÎÒÃÇ¿ÉÒÔ²»¶ÔÊäÈëºÍÊä³öÊý¾Ý¿âµÄ×Ö·û´®Êý¾Ý×÷
addslashes()ºÍstripslashes()µÄ²Ù×÷,Êý¾ÝÒ²»áÕý³£ÏÔʾ¡£ Èç¹û´ËʱÄã¶ÔÊäÈëµÄÊý¾Ý×÷ÁËaddslashes()´¦Àí£¬
ÄÇôÔÚÊä³öµÄʱºò¾Í±ØÐëʹÓÃstripslashes()È¥µô¶àÓàµÄ·´Ð±¸Ü¡£ 2. ¶ÔÓÚPHP magic_quotes_gpc=off µÄÇé¿ö ±ØÐëÊ¹Ó ......

My sqlÖÐÎÄÂÒÂëÎÊÌ⣡

      Õ⼸ÌìÒ»Ö±±»ÖÐÎÄÂÒÂëÎÊÌâÀ§ÈÅ£¬ÖÐÎÄÊý¾Ý²åÈëµ½My SqlÖкÜÕý³££¬ÔÚCommand client lineÖÐÒ²ÄÜÕý³£ÏÔʾ£¬¿É´ÓÊý¾Ý¿âÖжÁµ½JSPÒ³ÃæÉÏʱ£¬¾Í±ä³É“»ðÐÇÎÄ”ÁË¡£
¡¡¡¡ÓÚÊÇÉÏÍø²éѯ£¬Ò²¿´µ½ºÃ¶à·½·¨£ºÓеÄ˵°Ñmy.iniÖÐdefault-character-set=latin1¸ÄΪdefault-character-set=utf8,ÓÐ ......

¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì SQL Server


¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì
 ¶àÌõ¼þ²éѯ´æ´¢¹ý³Ì ÀýÒ»
create proc pr_select_Natural
(
 @CDATE  datetime,
 @FAC_NAME varchar(50),
 @BATTERY_TYPE varchar(20),
 @MAKE_MODE varchar(20),
 @PRODUCE_MODE varchar(20),
 @YEAR  char(4),
 @MONTH  char(2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ