±Ê¼Ç±¾
                                                          ÊÖ»ú
                                                          ÄÚ´æ
                                                          cpu
                                                          ͶӰ»ú
                                                          Ö÷°å
                                                          ÊýÂë
                                                          ÏÔ¿¨
                                                          ÏÔʾÆ÷
                                                          ÍøÂç
                                                          ·þÎñÆ÷
                                                          MP3
                                                          ´òÓ¡»ú
                                                            ÐÅÑôµçÄÔÍøÊ×Ò³|µçÄÔ×ÊѶ|µçÄÔÐÐÇé|µçÄÔµ¼¹º|µçÄÔÓ²¼þ|½µ¼Û·ç±©|ÏÂÔØÖÐÐÄ|×°»ú±Ø±¸|Èí¼þÏÂÔØ|Ô´ÂëÏÂÔØ|½Ì³ÌÏÂÔØ|ͼƬÖÐÐÄ|ÍøÕ¾½¨Éè|¹ã¸æÍ¶·Å|  
                                                          |×îÐÂÊÓµã|Èí¼þÐÂÎÅ|ÍøÒ³ÖÆ×÷|ͼÏñ´¦Àí|ýÌåÓ¦ÓÃ|²Ù×÷ϵͳ|ÊýÂë¼¼Êõ|±à³ÌÉè¼Æ|Êý¾Ý¿âÀà|ÍøÂ簲ȫ|°ì¹«Èí¼þ|µÈ¼¶¿¼ÊÔ|ÈËÎïר·Ã|ÐÅÑô½ÌÓý|ITÀàÐÂÎÅ
                                                          |ÐÂÎÅÊÓÆµ|ÌåÓýÐÂÎÅ|¾üÊÂÐÂÎÅ|Éç»áÐÂÎÅ|ÐÅÑôÐÂÎÅ|ÐÅÑôÉè¼Æ|½¡¿µÒûʳ|¼Ò¾Ó×°ÐÞ|ÐÅÑôÂÃÓÎ|ÐÅÑôÉ̼Ò|ÐÅÑô»éÇì|ÐÅÑôÃÀʳ|ÐÅÑô»ÆÒ³|ÐÅÑô±ö¹Ý|ÐÅÑô½¨²Ä
                                                          |Éú»î·þÎñ|ÐÅÑôë¼â|ÐÅÑôÃûÈË|ÐÅÑô·¿²ú|ÐÅÑôÓéÀÖ|ÐÅÑô³µÊÐ|Êг¡ÐÅÏ¢|¶þÊÖÊг¡|ÐÅÑôÈ˲Å|¿¨Í¨¶¯Âþ|µç×ÓÉÌÎñ|µçÄԿƼ¼|¹«Ë¾ÆóÒµ|Æû³µÍ¼Æ¬|ÓéÀÖͼƬ
                                                          ÐÅÑôITȨÍþÃÅ»§ÍøÕ¾
                                                           
                                                          ÄúÏÖÔÚµÄλÖ㺠ÐÅÑôITµÚÒ»ÃÅ»§ÍøÕ¾ >> ÐÂÎÅÖÐÐÄ >> Êý¾Ý¿âÀà >> ÕýÎÄ
                                                          SQL ´æ´¢¹ý³Ì&Ëã·¨
                                                          ×÷ÕߣºØýÃû ÎÄÕÂÀ´Ô´£º»¥ÁªÍø µã»÷Êý£º ÔÚÏßͶ¸å Ͷ¸åÖ¸ÄÏ

                                                          ´úÂ뻹ÔÚÍêÉÆÖÐ

                                                          if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
                                                          drop table [dbo].[t]
                                                          GO

                                                          CREATE TABLE [dbo].[t] (
                                                           [id] [int] IDENTITY (1, 1) NOT NULL ,
                                                           [lid] [nvarchar] (50) ,
                                                           [name] [nvarchar] (50) ,
                                                           [type] [int] NOT NULL
                                                          )
                                                          GO

                                                          insert into t (lid,[name],[type])
                                                          select "11","³ÇÕ¾»ð³µÕ¾",0
                                                          union all select "11","¿ûÏィ¹ú·¿Ú",0
                                                          union all select "11","²ËÊÐÇÅ",0
                                                          union all select "11","³±ÃùËÂÏï",0
                                                          union all select "11","±¦ÉÆÇލ¹ú·¿Ú",0
                                                          union all select "11","±¦ÉÆÇÅ",0
                                                          union all select "11","ÊÐÌåÓý¹Ý",0
                                                          union all select "11","ÎäÁֹ㳡",0
                                                          union all select "11","ÎäÁÖÃÅ",0
                                                          union all select "11","ÎäÁÖÃÇñRëó·¿Ú",0
                                                          union all select "11","°Ë×ÖÇÅ",0
                                                          union all select "11","Õã´óÎ÷ÏªÐ£Çø",0
                                                          union all select "11","Çì·á´å",0
                                                          union all select "11","½Ì¹¤Â·¿Ú",0
                                                          union all select "11","»¨Ô°ÐÅ´å",0
                                                          union all select "11","Õã½­¹¤ÉÌ´óѧ",0
                                                          union all select "11","µç×ӿƼ¼´óѧ",0
                                                          union all select "11","´äÔ·ÐÅ´å",0
                                                          union all select "57","´ó¹ØÐ¡Çø",0
                                                          union all select "57","ͨÐÅÊг¡",0
                                                          union all select "57","µÂʤÐÅ´å",0
                                                          union all select "57","³±Íõ·¿Ú",0
                                                          union all select "57","³¯êÍÎåÇø",0
                                                          union all select "57","³¯êÍÈýÇø",0
                                                          union all select "57","Î÷ºþÎÄ»¯¹ã³¡¶«",0
                                                          union all select "57","ÎäÁֹ㳡",0
                                                          union all select "57","ÎäÁÖС¹ã³¡",0
                                                          union all select "57","°ëµÀºì",0
                                                          union all select "57","ÎÄÈý·¿Ú",0
                                                          union all select "57","ÉÏÄþÇÅ",0
                                                          union all select "57","»¨Ô°ÐÅ´å",0
                                                          union all select "57","Õã½­¹¤ÉÌ´óѧ",0
                                                          union all select "57","ÎÄһ·¿Ú",0
                                                          union all select "57","½Ì¹¤Â·±±¿Ú",0
                                                          union all select "57","´ó¹ØÇÅÎ÷",0
                                                          union all select "57","ÉÏÌÁ·¿Ú",0
                                                          union all select "57","´ó¹ØÎ÷ÁùÔ·",0
                                                          union all select "57","Ïã»ýË·¿Ú",0
                                                          union all select "57","´ó¹ØÐ¡Çø",0
                                                          union all select "14","ÎäÁÖС¹ã³¡",0
                                                          union all select "14","²ý»¯ÐÅ´å",0
                                                          union all select "14","³¤ÊÙÇÅ",0
                                                          union all select "14","ÑÓ°²Â·¿Ú",0
                                                          union all select "14","Öдó¹ã³¡",0
                                                          union all select "14","ÖÚ°²ÇÅ",0
                                                          union all select "14","ÕãÒ»Ò½Ôº",0
                                                          union all select "14","´óѧ·±±¿Ú",0
                                                          union all select "14","Çì´ºÃÅ",0
                                                          union all select "14","½ðÑÃׯ",0
                                                          union all select "14","×ܹÜÌÁ",0
                                                          union all select "14","»ª¶«¼Ò¾ßÊг¡",0
                                                          union all select "14","½ü½­´å",0
                                                          union all select "14","Æû³µÄÏÕ¾",0
                                                          union all select "14","Æû³µÄÏÕ¾",1
                                                          union all select "14","½ü½­´å",1
                                                          union all select "14","»ª¶«¼Ò¾ßÊг¡",1
                                                          union all select "14","×ܹÜÌÁ",1
                                                          union all select "14","½ðÑÃׯ",1
                                                          union all select "14","Çì´ºÃÅ",1
                                                          union all select "14","´óѧ·±±¿Ú",1
                                                          union all select "14","ÕãÒ»Ò½Ôº",1
                                                          union all select "14","ÖÚ°²ÇÅ",1
                                                          union all select "14","Öдó¹ã³¡",1
                                                          union all select "14","ÑÓ°²Â·¿Ú",1
                                                          union all select "14","³¤ÊÙÇÅ",1
                                                          union all select "14","²ý»¯ÐÅ´å",1
                                                          union all select "14","ÎäÁÖС¹ã³¡",1
                                                          union all select "K105","»ð³µ¶«Õ¾",0
                                                          union all select "K105","Æû³µ¶«Õ¾",0
                                                          union all select "K105","ÑϼÒŪ",0
                                                          union all select "K105","¾°·¼ÎåÇø",0
                                                          union all select "K105","¾°Óù·¿Ú",0
                                                          union all select "K105","Çì´º¶«Â·",0
                                                          union all select "K105","²ÉºÉÐÅ´å",0
                                                          union all select "K105","¹ÛÒôÌÁÐ¡Çø",0
                                                          union all select "K105","×ܹÜÌÁ",0
                                                          union all select "K105","Õ¼ÒÇÅ",0
                                                          union all select "K105","Õã¶þÒ½Ôº",0
                                                          union all select "K105","¹ÙÏï¿Ú",0
                                                          union all select "K105","ºþ±õ",0
                                                          union all select "K105","ʤÀû¾çÔº",0
                                                          union all select "K105","º¢¶ùÏï",0
                                                          union all select "K105","ÑÓ°²ÐÅ´å",0
                                                          union all select "K105","ÎäÁÖС¹ã³¡",0
                                                          union all select "K105","º¼ÖÝ´óÏÃ",0
                                                          union all select "K105","Öб±ÇÅ",0
                                                          union all select "K105","Ê©¼ÒÇÅ",0
                                                          union all select "K105","½¨¹ú±±Â·ÎÄêÍ·¿Ú",0
                                                          union all select "K105","ÎÄêÍ´óÇŶ«",0
                                                          union all select "K105","»úÉñ´å",0
                                                          union all select "K105","Ìì³Ç·¿Ú",0
                                                          union all select "K105","ÐÅÌÁ·¿Ú",0
                                                          union all select "K105","»ð³µ¶«Õ¾",0
                                                          union all select "39","Õ¢¿Ú",0
                                                          union all select "39","Ë®³ÎÇÅ",0
                                                          union all select "39","º£ÔÂÇÅ",0
                                                          union all select "39","ÃÀÕþÇÅ",0
                                                          union all select "39","¸´ÐË·±±¿Ú",0
                                                          union all select "39","ÈýÀÈÃí",0
                                                          union all select "39","ãå²ÄÐÅ´å",0
                                                          union all select "39","¶þÁ¹Í¤",0
                                                          union all select "39","Íû½­ÃÅÍâ",0
                                                          union all select "39","Æû³µÄÏÕ¾",0
                                                          union all select "39","½ü½­´å",0
                                                          union all select "39","»ª¶«¼Ò¾ßÊг¡",0
                                                          union all select "39","×ܹÜÌÁ",0
                                                          union all select "39","³ÇÕ¾»ð³µÕ¾",0
                                                          union all select "K101","³ÇÕ¾»ð³µÕ¾",0
                                                          union all select "K101","×ܹÜÌÁ",0
                                                          union all select "K101","¹ÛÒôÌÁÐ¡Çø",0
                                                          union all select "K101","²ÉºÉÐÅ´å",0
                                                          union all select "K101","ºìÁâÐÅ´å",0
                                                          union all select "K101","·ïÆð¶«Â·¿Ú",0
                                                          union all select "K101","Ë«Áâ·±±¿Ú",0
                                                          union all select "K101","Êкì»áÒ½Ôº",0
                                                          union all select "K101","½¨¹ú·¿Ú",0
                                                          union all select "K101","ÐÅ»ªÂ·¿Ú",0
                                                          union all select "K101","Öб±Â·¿Ú",0
                                                          union all select "K101","ÑÓ°²Â·¿Ú",0
                                                          union all select "K101","Õã´óºþ±õÐ£Çø",0
                                                          union all select "K101","²ý»¯ÐÅ´å",0
                                                          union all select "K101","Êи®´óÂ¥",0

                                                          [1] [2] ÏÂÒ»Ò³

                                                          ÐÅÑôµçÄÔÍøÉêÃ÷:±¾Õ¾×ÊÔ´À´Ô´ÓÚ»¥ÁªÍø,°æÈ¨¹éÔ­×÷ÕßËùÓУ¬ÈçÓÐÇÖȨÇëÁªÏµÎÒÃÇ,ÎÒÃǽ«ÔÚÊÕµ½ÏûÏ¢ºó24СʱÄÚɾ³ý.

                                                        1. ÉÏһƪÎÄÕ£º
                                                        2. ÏÂһƪÎÄÕ£º
                                                        3. ¡¾×ÖÌ壺С ´ó¡¿¡¾·¢±íÆÀÂÛ¡¿¡¾¼ÓÈëÊղء¿¡¾¸æËߺÃÓÑ¡¿¡¾´òÓ¡´ËÎÄ¡¿¡¾¹Ø±Õ´°¿Ú¡¿

                                                          ¡¡¡¡ÍøÓÑÆÀÂÛ£º£¨Ö»ÏÔʾ×îÐÂ10Ìõ¡£ÆÀÂÛÄÚÈÝÖ»´ú±íÍøÓѹ۵㣬Óë±¾Õ¾Á¢³¡Î޹أ¡£©

                                                          Ê×Ò³ÍÆ¼ö

                                                          7Çò¶Ó»òÔÚÑ¡Ðãµ±Ìì½»Ò×:¡­
                                                          ÍÆ¼öÎÄÕ Ů´óѧÉý»áÍøÓÑ͵×ß¶Ô·½¼ÛÖµ8ÍòÃû±í
                                                          ÍÆ¼öÎÄÕ ´óÁ¬»¤Ê¿ÃÅʼþ¡°»¤Ê¿ÃÅ¡±ÕÕÆ¬È«¼¯
                                                          ÍÆ¼öÎÄÕ һ¿éÇ®ÈÎÄãÃþµÄ¸£~ÎñÐÐÒµ¾ªÏÖ¹úÄÚ£¬Ö»ÐèÒ»¿éÇ®ÈÎÄã¡­
                                                          ÍÆ¼öÎÄÕ ÍâÃ½ÆØ¹âÖйúÔÙ´«Õðº³ÏûÏ¢£ºÎÒ¾üÓÖÁÐ×°ÐÅɱÊÖïµ
                                                          ÍÆ¼öÎÄÕ ÖÐÃÀ¡°ÐÅ×¼Ôò¡±ÒõÓ°ÁýÕÖÓ¡¶È£º°¢ÈýºÜÅÂÖÐÃÀÁªÊÖ
                                                          ÍÆ¼öÎÄÕ ÃÀ¾ü¶Ô»ª¾¯±¨Ô½À­Ô½Ï죺ÖÐÃÀÌì¾üÌ«¿ÕÕ½ËæÊ±¿ª´ò
                                                          ÍÆ¼öÎÄÕ һ´¥¼´·¢£ºÃÀ¾ü¶¥¼¶Ç±Í§º½Ä¸±Æ½üÖйúÄÚÄ»ÆØ¹âÁË
                                                          ÍÆ¼öÎÄÕ º½Ä¸µÈ²»¼°ÁË£¡Öйú½¨³É¼ß15º½Ä¸½¢ÔØ»úѵÁ·»ùµØ
                                                          ¾«²ÊÐÅÏ¢
                                                           Ò»±¾¹ØÓÚÊý¾Ý¿âµÄÊé¼®
                                                           Ê¹ÓÃSQL×ÓÑ¡ÔñÀ´ºÍ²¢²éѯ
                                                           ²éѯ¶à¸ö±í¸ñ
                                                           ´´½¨ºÍÐ޸ıí¸ñ
                                                           ´®ÐÐÊý¾ÝÀàÐÍ
                                                           ¸úÎÒѧSQL£º(Æß)´Ó×Ó±íÀïɾ³ýÊý¾Ý
                                                           ¸úÎÒѧSQL£º(°Ë)ÊýÖµÊý¾ÝÀàÐÍ
                                                           datetimeºÍintervalÊý¾ÝÀàÐÍ
                                                           Î¢ÈíSQL Server 2005µÄ30Ïî¶¥¼âÌØÐÔ
                                                           Coca-Cola ÏµÁÐtrexi¹«×Ð
                                                          ͼÎÄÐÅÏ¢

                                                          Ò»±¾¹ØÓÚÊý¾Ý¿âµÄÊé¼®

                                                          Coca-Cola ÏµÁÐtrexi¹«¡­

                                                          ÆÊÎöSQL Server 2005²é¡­

                                                          JDBCÁ¬½ÓSQL2000ÏêϸÁ÷¡­
                                                          ÉèΪÊ×Ò³ - ¼ÓÈëÊÕ²Ø - ¹ã¸æ·þÎñ - ÓÑÇéÁ´½Ó - ÁªÏµÎÒÃÇ - °æÈ¨ÉêÃ÷ - ÍøÕ¾½¨Éè - °ïÖú
                                                          Ô¥ICP±¸10021913ºÅ  ±¾Õ¾ÉùÃ÷£º±¾Õ¾×ÊÔ´À´Ô´ÓÚ»¥ÁªÍø,°æÈ¨¹éÔ­×÷ÕßËùÓУ¬ÈçÓÐÇÖȨÇëÁªÏµÎÒÃÇ,ÎÒÃǽ«ÔÚÊÕµ½ÏûÏ¢ºó24СʱÄÚɾ³ý.
                                                          © CopyRight 2002-2008, www.drbattles.com, Inc. QQ:869696845 ¹Ù·½¢ÙȺ:58890563(Âú)¹Ù·½¢ÚȺ:58890410
                                                             
                                                          ·ï»Ë²ÊÆ±ÍøÕ¾