¼±£¬sql±»×¢Èë
sqlÊý¾Ý¿âÀï´ó²¿·Ý±í±»×¢Èë" <script src=http://z360.net> </script>"Ö®À࣬³ÌÐòÒѾÔÚÐÞ¸ÄÁË.
ÊÇÓÃľÂí×¢ÈëµÄÂð?Èç¹ûÊÇľÂí×¢ÈëµÄÎÒ¸ÃÔÚÄÄÀïɱľÂí£¬¿Í»§¶Ë»¹ÊÇ·þÎñÆ÷¶Ë
¿Ï¶¨ÊÇÄã³ÌÐòûÓйýÂËSQL×¢Èë¡£
¼ì²é³ÌÐò²ÎÊý³ÌÐò¡£
ÎÒÏÖÔÚÏÞÖÆµÄÊÇÔÚget´«ÖµµÄʱºò£¬ºÍÒ»ÇÐÓû§ÓÐÊäÈëµÄµØ·½£¬»¹ÓÐÆäËûµØ·½ÐèÒªÏÞÖÆÂ𣿱ÈÈçsession,cookie
ÔÚ¿Í»§¶ËºÍ·þÎñÆ÷¶¼Òª·À»¤£¬Êý¾Ý¿â²Ù×÷ʹÓòÎÊý£¬½ûֹһЩÃüÁî
http://topic.csdn.net/u/20090729/14/26381958-0d6e-4b90-bc90-d275e9621f93.html
http://topic.csdn.net/u/20090708/09/b78444ee-9081-4ff7-8aa5-ba6f9b1d9fdc.html
cookieҲҪעÒâ°¡£¬
ÅжÏÓû§ÓÐû¿ÉÄÜÐÞ¸Äcookie´ïµ½ÆÆ»µ×÷Óá£
session¾Í²»ÓÃÁË¡£
²ÎÊý£¬¹ýÂË.ÎÒÖªµÀ£¬ÎÒÊÇÓýӱðÈ˵ÄÍøÕ¾
ÎÒÏëÖªµÀËû×¢ÈëÊÇÓÃľÂíÂð£¿
±ÈÈç˵¿Í»§¶ËÓÐľÂí£¬×Ô¶¯´óÅúÁ¿×¢Èë <script src=http://z360.net> </script>
ÊÇÕâÑùÂ𣿳ÌÐòÈç¹û¹æ·¶ºÃ£¬»¹ÐèÒª×öʲô
Óû§ÊäÈëµÄµØ·½Ò»¶¨Òª¹ýÂ˵ô¹Ø¼ü×Ö
Èçjs½Å±¾¡¢sql¹Ø¼ü×Ö
±ÈÈç˵¿Í»§¶ËÓÐľÂí£¬×Ô¶¯´óÅúÁ¿×¢Èë <script src=http://z360.net> </script>
ÊÇÕâÑùÂ𣿳ÌÐòÈç¹û¹æ·¶ºÃ£¬»¹ÐèÒª×öʲô
´ó¼Ò¶¼ÖªµÀÊÇÈçºÎ×¢ÈëµÄ£¬ÎÒÏëÖªµÀµÄÊÇÈçºÎÅúÀí×¢È룬ľÂí£¿ÎÒÊDz»ÊǵÃɱÏÂľÂí
Èç¹ûÒ³ÃæÓÐÕâ¶Î´úÂë»á³öÏÖÏÂÃæµÄ´íÎóÌáʾ¡£
ºÚ¿ÍÊÇÔõôעÈëµÄ£¬ÎÒºÜÏëÖªµÀ¡£
¡°/WebSite1¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
´
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
ÓÐÁ½ÌõSQLÓï¾ä£¨Ò»¸ö¿ªÊ¼Ò»¸ö½áÊø£©£¬ÎÒÏëÔÚ×ÀÃæÉÏÖ´ÐУ¬¹âÌý˵Ҫ×ö¸ö´°Ì廹ÊǿؼþµÄ£¬ÕâÔõô×ö£¿ÇóÀÏʦÃǰïæ£¬ÏÈлл£¡£¡£¡£¡
ʲôÒâ˼£¬Â¥Ö÷˵Çå³þЩ
...ÊÇѽ£¬ÏÈ˵Çå³þÂï
£¿
ÎÒµÄÒâ˼ÊÇ˵ÔÚ×ÀÃæÉÏ×ö¸ö ......
select a.fyear,b.fname,
'1ÔÂ'=case when fperiod=1 then sum(a.fendbal) else 0 end ,
'2ÔÂ'=case when fperiod=2 then sum(a.fendbal) else 0 end ,
'3ÔÂ'=case when fperi ......