vs2008ÔõôÕýÈ·µ¼Èë·Çexpress°æµÄsqlserverÊý¾Ý¿âÎļþ
VS2008Íù½â¾ö·½°¸ÖÐÌí¼Ó¡°»ùÓÚ·þÎñµÄÊý¾Ý¿â¡±Ïîʱ·¢ÉúÏÂÃæµÄ´íÎó£º
---------------------------
Microsoft Visual Studio
---------------------------
Óë SQL Server Îļþ(*.mdf)µÄÁ¬½ÓÒªÇó°²×° SQL Server Express 2005 ²ÅÄÜÕý³£¹¤×÷¡£ÇëÈ·ÈÏÊÇ·ñ°²×°Á˸Ã×é¼þ£¬¸Ã×é¼þ¿É´ÓÒÔÏ URL ÏÂÔØ: http://go.microsoft.com/fwlink/?LinkId=49251
---------------------------
ÎÒ»úÆ÷Öа²×°µÄSQL Server 2005ÊÇ¿ª·¢°æ¡£ÔÚVSÖÐÓà ¡°¹¤¾ß->Á¬½Óµ½Êý¾Ý¿â¡±¿ÉÒԳɹ¦µØÁ¬½Óµ½±¾µØ·þÎñÆ÷¡£
ÎÒÔÚÍøÉϲ鿴ÁËһЩ½â¾ö·½°¸£¬Ê¹ÓÃÐÞ¸ÄʵÀýÃû³ÆºÍmachine.configÖÐ×Ö·û´®µÄ·½·¨Ã»ÓÐ×÷Óá£
ÁíÍ⣬ÎÒÖ»¿ªÆôÁËSQL SERVER£¨MSSQLSERVER£©ÕâÏî·þÎñ£¬ÆäÓ඼½ûÖ¹ÁË£¬Õâ¸öÓÐÓ°Ïìô£¿
ÇëÎÊÔõô½â¾ö£¿
Visual StudioµÄSQL×é¼þ´´½¨Êý¾Ý¿âÖ»Ö§³ÖSQL Server Express...
×Ô¼ºÓÃSQL Server Management Studio»òÃüÁîÐй¤¾ßsqlcmd¡¢osqlµÈ¹ÜÀí£¬²»ÒªÌ«ÒÀÀµ¹¤¾ß...
²»»á°É...
ÎÒÓÿª·¢°æ¾ÍÊÇÏëÓÃSSMSÀ´Ñ§Ï°¡¢¹ÜÀíÊý¾Ý¿â£¬ÏÖÔÚµÄÎÊÌâÊÇΪʲôVSÃ÷Ã÷¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â£¬µ«ÊÇÌí¼Ó¡°»ùÓÚ·þÎñµÄÊý¾Ý¿â¡±Ïîʱ¾Í±ØÐëÊÇSQL Server Express°æ±¾µÄ°¡£¿
ÔÙ˵£¬ÎÒ¿´¹ýһЩÌû×Ó£¬VS²¢Ã»ÓÐÄÄÀïдÁ˹涨ǿÖƺÍSQL Server ExpressÅäºÏ°¡¡£
¶¥ÏÂ×Ô¼º£¡
²»»á°É...
ÎÒÓÿª·¢°æ¾ÍÊÇÏëÓÃSSMSÀ´Ñ§Ï°¡¢¹ÜÀíÊý¾Ý¿â£¬ÏÖÔÚµÄÎÊÌâÊÇΪʲôVSÃ÷Ã÷¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â£¬µ«ÊÇÌí¼Ó¡°»ùÓÚ·þÎñµÄÊý¾Ý¿â¡±Ïîʱ¾Í±ØÐëÊÇSQL Server Express°æ±¾µÄ°¡£¿
ÔÙ˵£¬ÎÒ¿´¹ýһЩÌû×Ó£¬VS²¢Ã»ÓÐÄÄÀïдÁ˹涨ǿÖƺÍSQL Server ExpressÅäºÏ°¡¡£
¶¥ÏÂ×Ô¼º£¡
vS×Ô´øµÄSQL SERVER ÓëÄã ×Ô¼º°²×°µÄ Á¬²»Éϵġ£¡£
ÕæµÄ²»ÐÐô£
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ LIJINING-PC¡£
------------------------------
ÆäËûÐÅÏ¢:
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÎó¡£ (provider: ¹²ÏíÄÚ´æÌṩ³ÌÐò, ......
ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â
°´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal
±ÈÈç
IP±í
IPStart IPEnd Address
-------------------------------------
994304000  ......
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÓÃsql server ×Ô´øµÄ¹¤¾ß
ÒýÓÃ
ÓÃsql server ×Ô´øµÄ¹¤¾ß
SQL²éѯ·ÖÎöÆ÷
DTSµ¼Èëµ¼³öÊý¾Ý
¿ÉÒÔÓÃSqlServer×Ô´øµÄ¹¤¾ß
ËùÓÐÈÎÎñ£µ¼³öÊý¾Ý¡£
ÄãÏÈÓòéÑ ......