csdn dotnet°æºÍsqlserver°æ½ØÖÁµ½2005Äê7ÔµÄfaqÏÂÔØ
http://download.csdn.net/source/1880537
http://download.csdn.net/source/1880503
ÏÈÕ¼¸öɳ·¢...
Õ¼¸ö×ù
ÎÒÊÇÓò»µ½µÄ¶«¶«
ÄÃ10·Ö×ßÈË~
ºÃµÄ
½Óµã·Ö¹ý¶¬¡£
¶¥¶¥
Õ¼×ù£¬Î§¹Û~
·¢Ï¹⣡˯¾õ£¡
°ï¶¥
ллŶ£¬ÕâЩ¶«Î÷º ......
sqlserver ÖÐµÄ ID ÈçºÎÉèÖóÉÏñaccessµÄ×Ô¶¯±àºÅÒ»Ñù ÿ´Î²åÈë¼Ç¼ ×Ô¶¯Éú³É ¶øÇÒ²»Öظ´
SQL code:
ÉèÖóÉ×ÔÔöÁÐ
id=identity(int,1,1)
±êʶÁÐ
SQL code:
create table tt(id int identity(1,1),name varchar(10))
insert into tt values('nn')
select * from tt
/*id ......
Êý¾Ý¿â½á¹¹£º
ServiceType ServiceSubmitTime
1 2008-07-24 13:03:24.000
2 2008-07-24 12:03:24.000
3 2008-07-23 13:03:24.000
4 2008-07-24 11:03:24.000
4 &nb ......
±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ WWW-B4E338630BB\SQLEXPRESS¡£
------------------------------
ÆäËûÐÅÏ¢:
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: SQL ÍøÂç½Ó¿ ......
sqlserverÊý¾Ý¿â¿É²»¿ÉÒÔÒÆÖµµ½±ðµÄµçÄÔÉÏ Êý¾Ý¿âÔÚ¹«Ë¾Àï ÎÒÏëŪ»Ø¼Ò µ«ÕÒ²»µ½ÏñaccessÄÇÑùµÄÎļþ
¿ÉÒÔ
¿ÉÒÔ
1
¿½貝mdf,ldf È»ááÄ¿標電腦¸½¼Ó
2
備·Ý È»ááÄ¿標電腦還Ô
±¸·Ý-»¹Ô
»òÕß
·ÖÀëÊý¾Ý¿â-¿½±´Êý ......
ÔÚ¶Ô¿âÖбí´ò¿ª£¬¶Áд£¬²éѯ²Ù×÷,ms sqlserver ÄÚ´æÊÇÈçºÎ±ä»¯µÄ£¬Èç¹û²Ù×÷¹ý¶àÊDz»ÊÇËü×ÜÊÇ»áÉêÇëеÄÄÚ´æ¿Õ¼ä×ÜÕ¼ÓÃ×Å£¿
¿´¿´Ö´Ðмƻ®¾ÍÖªµÀÁË
˵µÃÌ«ÉîÁË£¬ÔÚ²Ù×÷ºóÄÚ´æÓÉ7µ½190M£¬²Ù×÷±È½ÏƵ·±£¬ÊdzÌÐò»¹ÊÇMS SQL SERVERµÄ´í£¿
Õâ¸ö˵²»ºÃ ÓпÉÄÜÊdzÌÐòûÓÐÊÍ·ÅÄÚ´æ ÓпÉÄÜÊÇSQLµÄI/O¿ªÏú
ÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐ ......