SQL Server 2005 Á¬½Ó×Ö·û´®´úÂë
SQL Native Client ODBC Driver
±ê×¼°²È«Á¬½Ó
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
ÄúÊÇ·ñÔÚʹÓÃSQL Server 2005 Express ÇëÔÚ“Server”Ñ¡ÏîʹÓÃÁ¬½Ó±í´ïʽ“Ö÷»úÃû³Æ\SQLEXPRESS”¡£
ÊÜÐŵÄÁ¬½Ó
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;
"Integrated Security=SSPI" Óë "Trusted_Connection=yes" ÊÇÏàͬµÄ¡£
Á¬½Óµ½Ò»¸öSQL ServerʵÀý
Ö¸¶¨·þÎñÆ÷ʵÀýµÄ±í´ïʽºÍÆäËûSQL ServerµÄÁ¬½Ó×Ö·û´®Ïàͬ¡£
Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;
Ö¸¶¨Óû§ÃûºÍÃÜÂë
oConn.Properties("Prompt") = adPromptAlways
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;
ʹÓÃMARS (multiple active result sets)
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;MARS_Connection=yes;
"MultipleActiveResultSets=true"ÓëMARS_Connection=yes"ÊÇÏàͬµÄ¡£
ʹÓÃADO.NET 2.0×÷ΪMARSµÄÄ£¿é¡£ MARS²»Ö§³ÖADO.NET 1.0ºÍADO.NET 1.1¡£
ÑéÖ¤ÍøÂçÊý¾Ý
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;Encrypt=yes;
ʹÓø½¼Ó±¾µØÊý¾Ý¿âÎļþµÄ·½Ê½Á¬½Óµ½±¾µØSQL Server ExpressʵÀý
Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
ΪºÎҪʹÓÃDatabase²ÎÊýÈç¹ûͬÃûµÄÊý¾Ý¿âÒѾ±»¸½¼Ó£¬ÄÇôSQL Server½«²»»áÖØÐ¸½¼Ó¡£
ʹÓø½¼Ó±¾µØÊý¾ÝÎļþ¼ÐÖеÄÊý¾Ý¿âÎļþµÄ·½Ê½Á¬½Óµ½±¾µØSQL Server ExpressʵÀý
Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;
ΪºÎҪʹÓÃDatabase²ÎÊýÈç¹ûͬÃûµÄÊý¾Ý¿âÒѾ±»¸½¼Ó£¬ÄÇôSQL Server½«²»»áÖØÐ¸½¼Ó¡£
Êý¾Ý¿â¾µÏñ
Data Source=myServerAddress;Failover Partner=myMirrorServer;Initial Catalog=myDataBase;Integrated Security=True;
SQL Native Client OLE DB Provider
±ê×¼Á¬½Ó
Provider=SQLNCLI;Server=myServerAddress;Database=myDataBas
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
truncate ¡¢deleteÓëdropÇø±ð
Ïàͬµã£º
truncate ºÍ²»´ø where ×Ó¾äµÄ delete£¬ÒÔ¼° drop ¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã£º
1. truncate ºÍ delete ֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
drop Óï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain)¡¢´¥·¢Æ÷(trigger)¡¢Ë÷Òý(index)£»ÒÀÀµÓڸñíµÄ´æ´¢¹ý³Ì/º¯Êý½«±£Áô,µ«ÊDZäΪ invalid ×´Ì ......
·½·¨1£º
Ò»¡¢ÕÒÒ»ÕÅSQL server·þÎñÆ÷°æ¹âÅÌ£¬ÔÚ¹âÅÌÉÏÕÒµ½Ä¿Â¼“MSDE”²¢½øÈ룬ÔËÐÐSETUP.EXEÎļþ£¬²¢°´ÕÕ³ÌÐòÒªÇó½øÐа²×°¡£°²×°Íê³ÉÖØÐÂÆô¶¯¼ÆËã»ú¡£
¶þ¡¢ÔËÐйâÅÌÖеģ¬AUTORUN.EXEÎļþ£¬»òÈùâÅÌ×Ô¶¯ÔËÐУ¬´ò¿ª°²×°½çÃæºó£¬
µã»÷“°²×°SQL server 2000×é¼þ£¨C£©”-->“°²×°Êý¾Ý¿â·þÎñÆ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create DATABASE database ......
ÓÉÓÚ×î½üÒªÓõ½´ò°üSQL Server 2005 Express Edition £¬ÓÉÓÚÔÚ°²×°¹ý³ÌÖÐÐèÒªÉèÖúܶණÎ÷¡£´øÀ´ºÜ¶àµÄ²»±ã£¬ÓÚÊÇÔÚÍøÉϺÍMSDNÕÒÁ˺þÃÖÕÓÚÕÒµ½°ì·¨ÁË ^_^
ÎÒÓõÄÊÇÅú´¦ÀíÀ´ÊµÏֵģ¬ºÃÁËÖ±½ÓÌù´úÂë
CLS
@ECHO OFF
ECHO.
ECH ......