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

sql serverÎÞ·¨Á¬½Ó issue

http://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
http://sqlserver.chinahtml.com/2006/SQL-mssql11432786154012.shtml
http://www.cnblogs.com/garnai/archive/2007/09/19/898221.html
http://tech.ccidnet.com/art/1099/20050223/214511_1.html
http://www.wangchao.net.cn/bbsdetail_43009.html


Ïà¹ØÎĵµ£º

sql Óï¾ä×ܽá

mysql :  ½«Ò»¸ö±íµÄÊý¾Ý²åÈëµ½newT ÖÐ
£¨newT ±íÐë´æÔÚ£¬ÇҽṹÓëselect Óï¾ä¶ÔÓ¦µÄ½á¹¹Í¬  £¬×îºÃ²»ÓÃ* ¶øÊǾßÌå×ֶΣ©    
       insert into newT select * from t1 where ...
Ò²¿ÉÒÔcreate table newT select f1,f2 from t1; (select into µÄÌæ´ú·½·¨£¬my ......

ÔÚSQL SERVERÖÐʵÏÖRSA¼ÓÃÜËã·¨

/***************************************************  
          ×÷Õߣºherowang(ÈÃÄãÍû¼ûÓ°×ÓµÄǽ£©
    ÈÕÆÚ£º2010.1.1
          ×¢£º    ×ªÔØÇë±£Áô´ËÐÅÏ¢
  & ......

ÈçºÎ´ÓEXPDPµ¼³öµÄÎļþÀï»ñµÃÓû§ÊÚȨµÄSQLÓï¾ä


ÈçºÎ´ÓEXPDPµ¼³öµÄÎļþÀï»ñµÃÓû§ÊÚȨµÄSQLÓï¾ä 
 
´òËãÇ¨ÒÆÒ»ÏµÍ³£¬ÓÉÓÚÊÇ¿çÆ½Ì¨µÄÇ¨ÒÆ£¬RMANÊDz»ÄÜÓÃÁË£¬¿¼ÂÇʹÓÃEXPDP/IMPDPÀ´½øÐе¼Èëµ¼³ö£¬µ¼Èë¹ý³Ì·¢ÏÖN¶àÓû§µÄȨÏÞ¸ã³öÁË£¬Âé·³ÖØµ¼ÊÇ¿ÉÒÔ»¨Ê±¼äÌ«³¤£¬Ñо¿ÁËһϣ¬Éú³ÉÁËÈ«²¿µÄSQLµÄ½Å±¾¡£
impdp system/manager schemas=user DIRECTORY=DUMP_FILES ......

SQL ServerÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ

Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Äã¶¼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâÆªÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾­Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......

[SQL Server 2005] hashÁª½ÓËã·¨

SQL Server 2005 hashÁª½ÓËã·¨
Èç¹ûÁ½¸öÁª½ÓÊäÈë¶¼ºÜ´ó£¬¶øÇÒÕâÁ½¸öÊäÈëµÄ´óС²î²»¶à£¬ÔòÔ¤ÏÈÅÅÐòµÄºÏ²¢Áª½ÓÌṩµÄÐÔÄÜÓë¹þÏ£Áª½ÓÏà½ü¡£µ«ÊÇ£¬Èç¹ûÕâÁ½¸öÊäÈëµÄ´óСÏà²îºÜ´ó£¬Ôò¹þÏ£Áª½Ó²Ù×÷ͨ³£¿ìµÃ¶à¡£
   ¹þÏ£Áª½Ó¿ÉÒÔÓÐЧ´¦ÀíδÅÅÐòµÄ´óÐÍ·ÇË÷ÒýÊäÈë¡£ËüÃǶԸ´ÔÓ²éѯµÄÖмä½á¹ûºÜÓÐÓã¬ÒòΪ£º
 &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ