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

SQLÖбí±äÁ¿ºÍÁÙʱ±íµÄÓÅȱµã

http://www.cnblogs.com/Mainz/archive/2008/12/20/1358897.html
ʲôÇé¿öÏÂʹÓñí±äÁ¿£¿Ê²Ã´Çé¿öÏÂʹÓÃÁÙʱ±í£¿
±í±äÁ¿£º
DECLARE @tb  table(id   int   identity(1,1), name   varchar(100))
INSERT @tb
SELECT id, name
from mytable
WHERE name like ‘zhang%’
ÁÙʱ±í£º
SELECT name, address
INTO #ta   from mytable
WHERE name like ‘zhang%’
±í±äÁ¿ºÍÁÙʱ±íµÄ±È½Ï£º
ÁÙʱ±íÊÇÀûÓÃÁËÓ²ÅÌ(tempdbÊý¾Ý¿â) £¬±íÃû±äÁ¿ÊÇÕ¼ÓÃÄڴ棬Òò´ËСÊý¾ÝÁ¿µ±È»ÊÇÄÚ´æÖеıí±äÁ¿¸ü¿ì¡£µ±´óÊý¾ÝÁ¿Ê±£¬¾Í²»ÄÜÓñí±äÁ¿ÁË£¬Ì«ºÄÄÚ´æÁË¡£´óÊý¾ÝÁ¿Ê±ÊʺÏÓÃÁÙʱ±í¡£
±í±äÁ¿È±Ê¡·ÅÔÚÄڴ棬Ëٶȿ죬ËùÒÔÔÚ´¥·¢Æ÷£¬´æ´¢¹ý³ÌÀïÈç¹ûÊý¾ÝÁ¿²»´ó£¬Ó¦¸ÃÓñí±äÁ¿¡£
Á٠ʱ±íȱʡʹÓÃÓ²ÅÌ£¬Ò»°ãÀ´ËµËٶȱȽÏÂý£¬ÄÇÊDz»ÊǾͲ»ÓÃÁÙʱ±íÄØ£¿Ò²²»ÊÇ£¬ÔÚÊý¾ÝÁ¿±È½Ï´óµÄʱºò£¬Èç¹ûʹÓñí±äÁ¿£¬»á°ÑÄÚ´æºÄ¾¡£¬È»ºóʹÓà TEMPDBµÄ¿Õ¼ä£¬ÕâÑùÖ÷Òª»¹ÊÇʹÓÃÓ²Å̿ռ䣬µ«Í¬Ê±°ÑÄÚ´æ»ù±¾ºÄ¾¡£¬Ôö¼ÓÁËÄÚ´æµ÷Èëµ÷³öµÄ»ú»á£¬·´¶ø½µµÍËٶȡ£ÕâÖÖÇé¿ö½¨ÒéÏȸøTEMPDBÒ»´Î·ÖÅäºÏÊʵĿռ䣬ȻºóʹÓÃÁÙʱ±í¡£
ÁÙʱ±íÏà¶Ô¶øÑÔ±í±äÁ¿Ö÷ÒªÊǶàÁËI/Oʱ¼ä£¬µ«ÉÙÁ˶ÔÄÚ´æ×ÊÔ´µÄÕ¼Óá£Êý¾ÝÁ¿½Ï´óµÄʱºò£¬ÓÉÓÚ¶ÔÄÚ´æ×ÊÔ´µÄÏûºÄ½ÏÉÙ£¬Ê¹ÓÃÁÙʱ±í±È±í±äÁ¿ÓиüºÃµÄÐÔÄÜ¡£
½¨Ò飺´¥·¢Æ÷¡¢×Ô¶¨Ò庯ÊýÓñí±äÁ¿£»´æ´¢¹ý³Ì¿´Çé¿ö£¬´ó²¿·ÖÓñí±äÁ¿£»ÌØÊâµÄÓ¦Ó㬴óÊý¾ÝÁ¿µÄ³¡ºÏÓÃÁÙʱ±í¡£
±í±äÁ¿ÓÐÃ÷È·µÄ×÷ÓÃÓò£¬ÔÚ¶¨Òå±í±äÁ¿µÄº¯Êý¡¢´æ´¢¹ý³Ì»òÅú´¦Àí½áÊøʱ£¬»á×Ô¶¯Çå³ý±í±äÁ¿¡£
ÔÚ´æ´¢¹ý³ÌÖÐʹÓñí±äÁ¿ÓëʹÓÃÁÙʱ±íÏà±È£¬¼õÉÙÁË´æ´¢¹ý³ÌµÄÖØбàÒëÁ¿¡£
Éæ¼°±í±äÁ¿µÄÊÂÎñÖ»ÔÚ±í±äÁ¿¸üÐÂÆÚ¼ä´æÔÚ¡£ÕâÑù¾Í¼õÉÙÁ˱í±äÁ¿¶ÔËø¶¨ºÍ¼Ç¼×ÊÔ´µÄÐèÇó¡£
±í±äÁ¿ÐèÒªÊÂÏÈÖªµÀ±í½á¹¹£¬ÆÕͨÁÙʱ±í£¬Ö»ÔÚµ±Ç°»á»°ÖпÉÓÃÓë±í±äÁ¿ÏàͬintoһϾͿÉÒÔÁË,·½±ã£»È«¾ÖÁÙʱ±í£º¿ÉÔÚ¶à¸ö»á»°ÖÐʹÓôæÔÚÓÚtempÖÐÐèÏÔʾµÄdrop¡££¨²»ÖªµÀ±í½á¹¹Çé¿öÏÂÁÙʱ±í·½±ãһЩ£©
È«¾ÖÁÙʱ±íµÄ¹¦ÄÜÊDZí±äÁ¿Ã»·¨´ïµ½µÄ¡£
±í±äÁ¿²»±Øɾ³ý£¬Ò²¾Í²»»áÓÐÃüÃû³åÍ»£¬ÁÙʱ±íÌرðÊÇÈ«¾ÖÁÙʱ±íÓõÄʱºò±ØÐë½â¾öÃüÃû³åÍ»¡£
Ó¦±ÜÃâƵ·±´´½¨ºÍɾ³ýÁÙʱ±í£¬¼õÉÙϵͳ±í×ÊÔ´µÄÏûºÄ¡£
ÔÚн¨ÁÙʱ±íʱ£¬Èç¹ûÒ»´ÎÐÔ²åÈëÊý¾ÝÁ¿ºÜ´ó£¬ÄÇô¿ÉÒÔʹÓÃselect into´úÌæcreate table£¬±ÜÃâlog£¬Ìá¸ßËٶȣ»Èç¹ûÊý¾ÝÁ¿²»´ó£¬ÎªÁË»ººÍϵͳ±íµÄ×ÊÔ´£¬½¨ÒéÏÈcreate table£¬È»ºói


Ïà¹ØÎĵµ£º

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨
Ò»£ºC# Á¬½ÓSQLÊý¾Ý¿â
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
Server=myServerAddress;D ......

SQL ServerºÍMySQLÖÐTopÓ÷¨µÄÇø±ð

      ½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
      ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
      1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * ......

Sql½ØÈ¡×Ö·û

 ×öÏîÄ¿ÀïÃæµÄÊý¾Ý¿âÉè¼ÆÁËÁ½¸öÀàÐÍ·ÅÒ»¸ö×Ö¶ÎÀïÃæ,ÎÒÓÖҪͨ¹ý·Ö¿ªµÄÀàÐÍÀ´½øÐвéѯ,Í´¿à°¡,
Á½ÖÖ·½·¨;
1,¶ÁÈ¡µ½»º´æÖÐ×Ô¶¨Òådatatable, ´úÂë¾Í²»ÌùÁË.
²»ÐÀÉÍÕâÖÖ×ö·¨,ÒòΪÎÒÒѾ­°ÑÒ³ÃæÉϺܶණÎ÷дÁË,¶¼ÊÇÓеÄSqlÓï¾ä,ÕâÑù¸Äһ϶¼Òª¸ÄÁË.
2.Ö±½ÓÔÚSqlÀïÃ潨ÊÓͼ,
lÓÃSUBSTRING(dbo.K_ProductDtl.Caizhi, 0, CH ......

ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿


ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“°²È«ÐÔ”£¬ÔÚ“·þÎñÆ÷Éí·ÝÑéÖ¤”ÀïÑ¡Ôñ“SQL ServerºÍWindows É ......

sql convertÈÕÆÚʱ¼ä¸ñʽ

--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÄêÔÂÈÕ
 select convert(varchar(10),getDate(),120)
--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÊ±·ÖÃë
select convert(varchar(8),getDate(),8)
Convertº¯ÊýµÄһЩ˵Ã÷£¬ÒÔÏÂ×ÊÁÏÀ´Ô´ÓÚÍøÂç
²»´øÊÀ¼ÍÊýλ (yy)
´øÊÀ¼ÍÊýλ (yyyy)

±ê×¼

ÊäÈë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ