EXCLEµ¼ÈëSQL ServerµÄÁ½¸öÎÊÌâ
½ñÌìÓöµ½Ò»¸ö¿Í»§£¬°Ñ×Ô¼ºÖ®Ç°¸éÖõÄÎÊÌâ°Úµ½ÁËÃæÇ°£¬´ëÊÖ²»¼°Ï´¦ÀíÆðÀ´×ßÁ˲»ÉÙÍä·£¬×îÖÕҲûÓÐÍêÈ«½â¾ö£¬Ö÷Òª»¹ÊǼ¼Êõ´¢±¸²»¹»¡£ÆäÖÐÓйØEXCLEÊý¾Ýµ¼ÈëSQL2000ʱÓöµ½Á½¸öÎÊÌ⣬ÔÚÍøÉÏËÑË÷Á˽â¾ö°ì·¨£¬ÊÕ²ØÒ»Ï£º
1¡¢½«Excelµ¼Èëµ½SQL severÊý¾Ý¿â£¬Ìáʾ˵“Íⲿ±í²»ÊÇÔ¤ÆÚµÄ¸ñʽ”
¿ÉÄܵÄÔÒò£ºÓбíÍ·¡¢»òÕßÊǸñʽÉÏÓкϲ¢µ¥Ôª¸ñÖ®ÀàµÄ
½â¾ö°ì·¨£º°Ñ±íÖеÄÊý¾Ý¸´ÖÆÒ»Ï£¬Ê¹ÓÃÖ»Õ³ÌùÊý¾Ýµ½Ò»¸öбíÖУ¬µ¼Èëбí
£¨Õª×Ôhttp://zhidao.baidu.com/question/86652526.html?fr=ala1£©
2¡¢ExcelÊý¾Ýµ¼ÈëSql Server³öÏÖNull
ÒýÆðµÄÔÒò£ºµ¼ÈëΪNullµÄÊý¾ÝÁÐÊôÓÚ»ìºÏÊý¾ÝÀàÐÍÁÐ
½â¾ö°ì·¨£ºÇ¿ÖƽâÎö——IMEX=1(ʹÓà IMEX=1 Ñ¡²ÎÖ®ºó£¬Ö»ÒªÈ¡ÑùÊý¾ÝÀïÊÇ»ìºÏÊý¾ÝÀàÐ͵ÄÁУ¬Ò»ÂÉÇ¿ÖÆ½âÎöΪ nvarchar/ntext Îı¾)
SELECT * INTO Table
from OpenDataSource
('Microsoft.Jet.OLEDB.4.0','Data Source="E:\1.xls";Extended properties="Excel 5.0;HDR=Yes;IMEX=1;"')...[Sheet1$]
£¨Õª×Ôhttp://hi.baidu.com/hackerxxw/blog/item/b5e5fcde4fb0f45c94ee3798.html£©
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
SqlCommand com = new SqlCommand("select * from myuser where username=@UserName and password=@Pwd", con);
com.Parameters.Add(new SqlParameter("@UserN ......
ÈçºÎÈ·¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾
Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
ÔËÐнá¹ûÈçÏ£º
²úÆ·° ......
ORACLE SQLÐÔÄÜÓÅ»¯
ORACLE SQLÐÔÄÜÓÅ»¯ÏµÁÐ (Ò»)
1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
a. RULE (»ùÓÚ¹æÔò) b. COST (»ùÓڳɱ¾) c. CHOOSE (Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊýµÄ¸÷ÖÖÉùÃ÷,ÈçRULE,COST,CHOOSE,ALL_ROWS,FIRST_ROWS . Ä㵱ȻҲÔÚSQ ......
µ±ÔÚÄÚÁ¬½Ó²éѯÖмÓÈëÌõ¼þʱ£¬ÎÞÂÛÊǽ«Ëü¼ÓÈëµ½join×Ӿ䣬»¹ÊǼÓÈëµ½where×Ӿ䣬ÆäЧ¹ûÊÇÍêȫһÑùµÄ£¬µ«¶ÔÓÚÍâÁ¬½ÓÇé¿ö¾Í²»Í¬ÁË¡£µ±°ÑÌõ¼þ¼ÓÈëµ½ join×Ó¾äʱ£¬»á·µ»ØÍâÁ¬½Ó±íµÄÈ«²¿ÐУ¬È»ºóʹÓÃÖ¸¶¨µÄÌõ¼þ·µ»ØµÚ¶þ¸ö±íµÄÐС£Èç¹û½«Ìõ¼þ·Åµ½where×Ó¾äÖУ¬½«»áÊ×ÏȽøÐÐÁ¬½Ó²Ù×÷£¬È»ºóʹÓÃwhere×Ó¾ä¶ÔÁ¬½ÓºóµÄÐнøÐÐɸѡ¡ ......