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ÌÐò½çÃæ£¬ºóÃæ ......
²éÑ¯ÖØ¸´Öµ£¬ÏÔʾ³ö²»Öظ´µÄ²¿·Ö
select distinct(employeeid) from orders
²éѯÁ½¸ö±íÖ®¼äÏàͬÊý¾Ý
select orders.EmployeeID,Employees.EmployeeID
from orders INNER JOIN Employees
on Employees.EmployeeID=orders.EmployeeID
ʵÏÖÄ¿µÄ£¬Ò»¸ö±í´æ·ÅÓû§±àºÅºÍÓû§Ãû£¬ÔÚÁíÒ»¸ö±íÖпÉÒÔ¸ù¾ÝÓû§±àº ......
1¡£Èç¹û×°sql serverÖÐδ³öÏÖÒì³£µÄ»°£¬ÇÒһЩ×ÔÑ¡²ÎÊý£¬ÕË»§£¬ÃÜÂëµÈûÓдíÎóµÄ»°¡£Ò»µ©³öÏÖÖîÈçsocket½¨Á¢²»Æð£¬Á¬½Ó²»ÉϵÈÎÊÌâ¡£×îÓÐЧµÄ½â¾ö·½·¨ÊÇ´ò²¹¶¡£¬ÆäÖÐsp4£ºhttp://www.microsoft.com/downloads/details.aspx?DisplayLang=zh-cn&FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5£¬sp3a£ºhttp://www.microsof ......
ÏÈÀ´Ò»¶Î´úÂ룺
WITH OrderedOrders AS
(SELECT *,
ROW_NUMBER() OVER (order by [id])as RowNumber¡¡¡¡--idÊÇÓÃÀ´ÅÅÐòµÄÁÐ
from table_info ) --table_infoÊDZíÃû
SELECT *
from OrderedOrders
WHERE RowNumber between 50 and 60;
ÔÚwindows server 2003, sql server 2005 CTP,P4 2.66GHZ,1GB ÄÚ´æÏ²âÊÔ£¬Ö´ÐÐʱ ......
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname ......