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

sql ÐÐתÁÐ

1¡¢ Ç¿´óµÄgroup by 1 select stdname,2 isnull(sum( case stdsubject when ' »¯Ñ§ ' then Result end), 0 ) [»¯Ñ§],3 isnull(sum( case stdsubject when ' Êýѧ ' then Result end), 0 ) [Êýѧ],4 isnull(sum( case stdsubject when ' ÎïÀí ' then Result end), 0 ) [ÎïÀí],5 isnull(sum( case stdsubject when ' ÓïÎÄ ' then Result end), 0 ) [ÓïÎÄ]6 from #student7 group by stdname ÔÚÕâÀgroup byÓësum + case½áºÏ£¬¿ÉÒÔ½«±í1ÖеļǼ£¨ÐУ©±ä³É±í2µÄ×ֶΣ¨ÁУ©¡£SumÀïÃæÈç¹ûûÓÐcase£¬ÄÇô³öÀ´µÄÖµ£¬Ö»ÄÜÊÇÈ«²¿¿ÆÄ¿µÄ×ܺͣ¬ÓÃÁËcaseÒԺ󣬾ÍÊÇij¿ÆµÄ³É¼¨£»È»ºóÕâÀïÓÃÁ˺ü¸¸ösum£¬Ã¿¸ö¿ÆÄ¿Ò»¸ösum£¬ÓÚÊDZí1Öб¾À´Ä³ÈËij¿ÆÕ¼Ò»Ìõ¼Ç¼µÄ"ÐÐ"¾Í±ä³ÉÁ˱í2ÀïijÈËÒ»Ìõ¼Ç¼£¬Ã¿¿Æ×öÒ»¸ö×Ö¶ÎÁË¡£ ÕâÖÖÐÄ˼ÇÉÃîºÍ¶ÔÓï·¨µÄÊìÁ·ÔËÓÃÈÃÈË»÷½ÚÔÞ̾¡£ 2¡¢ ÀûÓÃselect from (select from)µÄģʽÉú³ÉSQLÓï¾ä 1 declare @sql varchar( 4000 )2 set @sql = ' select stdname '3 select @sql = @sql + ' ,isnull(sum(case stdsubject when ''' + stdsubject + ''' then Result end),0) [ ' + stdsubject + ' ] '4 from (select distinct stdsubject from #student) as a5 select @sql = @sql + ' from #student group by stdname '6 print @sql7 exec(@sql) ΪÁË×Ô¶¯Ð´ÉÏËùÓеĿÆÄ¿£¬ÕâÀïÏȽ«¿ÆÄ¿ÐÅÏ¢ÌáÁ¶³öÀ´£º 4 from (select distinct stdsubject from #student) as a ÀûÓÃ֮ƴ½ÓÉú³ÉSQLÓï¾ä¡£µ±È»ÏÖʵÖУ¬Èç¹û#student±íºÜ´ó£¬ÕâÖÖ×ö·¨²¢²»Í×£¬Ó¦¸Ã¶¼ÓÐÒ»¸öרÃŵĿÆÄ¿Àà±ð±íµÄ¡£ 3¡¢ ÔÚÁÙʱ¿âÖÐÌáÁ¶³ö×Ö¶ÎÃû¡£ÁÙʱ±íÊÇÕæÊµ´æÔÚµÄ±í£¬±£´æÔÚ[tempdb]ÖУ¬¿ÉÒÔÀûÓÃobject_id('tempdb.dbo.±íÃû')µÄ·½Ê½»ñµÃ×Ö¶ÎÐÅÏ¢¡£ ============================================ ¸½Â¼£º http://www.cnblogs.com/zhanglei644213943/archive/2009/12/27/1633356.html ×ÝÀÀ¸÷´óÉçÇø¡¢ÂÛ̳£¬¸÷´ó ORM¿ò¼Ü»ðµÃ²»ÐÐÁË£¬ÈçNHibernate¡¢LINQ to SQL¡¢ADO.NET Entity frameworkµÈ£¬»¹ÓÐ×î½üÊг¡Éϳö°æµÄÒ»±¾½Ð¡¶ÁìÓòÇý¶¯Éè¼ÆÓëģʽʵս¡·£¬ÀïÃæÒ²Í¹ÏÔÁ˲»ÉÙNHibernateÔÚÁìÓòÇý¶¯Éè¼ÆÖеÄ×÷ÓÃÓëµØÎ»£¬Ò²ËãÊǵÚÒ»±¾ÓëNHibernateÏà¹ØµÄÊé¼®°É£¡²»¹ý¾ÍNHibernate¶øÑÔ»¹ÊÇûÓйٷ½Îĵµ½éÉܵÃÏêϸºÇºÇ£¬Ô°×ÓÀïKiler ÒѾ­°ÑËû·­Òë³ÉÖÐÎİæµÄÁË£¬ÊÕÒæÒ»´óƬ½ö½öÊÇCET-4µÄÈË¡£²»¹ÜÄãÊÇÓÃNHibernateÒ²ºÃ£¬»¹ÊÇÓÃLINQ to SQLÒ²ºÃ£¬ÓÃprofilerÒ»¸ú×Ù£¬Ö´ÐеͼÊÇSQLÓï¾ä£¬ËùÒÔËùSQLÊǸù¡£ÌرðÊǶÔ


Ïà¹ØÎĵµ£º

sqlÓÅ»¯50Ìõ

ËäÈ»²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬µ«ÊÇÈç¹ûͨ¹ýÒ»¶¨µÄÓÅ»¯£¬Ò²¿ÉÒÔʹ²éѯÎÊÌâµÃµ½Ò»¶¨³Ì¶ÈµÄ½â¾ö¡£ ²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
     1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
     2¡¢i/oÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
   &n ......

¸øPL/SQL´´½¨Õ˺š¢ÃÜÂëºÍ¸¶È¨ÏÞ

¸øPL/SQL´´½¨Õ˺š¢ÃÜÂëºÍ¸¶È¨ÏÞ
CREATE USER zxd  PROFILE "DEFAULT" IDENTIFIED BY zxd DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
grant dba to "zxd";
F:\oracle\ora92\network\admin  Â·¾¶ÏÂtnsnames.ora
ZXD =
  (DESCRIPTION =
  &nb ......

ODBCÁ¬½Ósybase sql anywhere open server

¾ßÌå²½Ö裺
¡¡¡¡Ò».ÔÚ·þÎñÆ÷¶ËÒÔ
dbsrv7.exe pathyyy.db -n
ServiceName -x tcpip -q
¡¡¡¡Æô¶¯Êý¾Ý¿â£¬ÕâÀïÒ²¿ÉÒÔÖ¸¶¨¶Ë¿Ú£¬ÏêϸµÄ²ÎÊýÇëÓÃdbsrv7.exe /?»ñÈ¡¡£
¡¡¡¡-n servicename:Æô¶¯·þÎñÃûΪservicenameµÄÊý¾Ý¿â·þÎñÓÃÒÔ±ê¼ÇÍøÂçÊý¾Ý¿â·þÎñΨһ±ê¼Ç£»
¡¡¡¡-x tcpip£ºÊ¹ÓÃtcp/ipЭÒ飬ĬÈ϶˿Ú3362,×¢Òâ²»Òª± ......

¼òµ¥SQLÓï¾äС½á


ΪÁË´ó¼Ò¸üÈÝÒ×Àí½âÎÒ¾Ù³öµÄSQLÓï¾ä£¬±¾Îļٶ¨ÒѾ­½¨Á¢ÁËÒ»¸öѧÉú³É¼¨¹ÜÀíÊý¾Ý¿â£¬È«ÎľùÒÔѧÉú³É¼¨µÄ¹ÜÀíΪÀýÀ´ÃèÊö¡£
¡¡¡¡1.ÔÚ²éѯ½á¹ûÖÐÏÔʾÁÐÃû£º
¡¡¡¡a.ÓÃas¹Ø¼ü×Ö£ºselect name as 'ÐÕÃû' from students order by age
¡¡¡¡b.Ö±½Ó±íʾ£ºselect name 'ÐÕÃû' from students order by age
¡¡¡¡2.¾«È·²éÕÒ:
¡¡¡¡a.Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ