Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlserver Êý¾Ý¿â±¸·ÝÎÊÌâ

ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£

µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database.bak'

µÚ¶þÖÖ·½·¨£º
Ñ¡ÔñÊý¾Ý-ÈÎÎñ-±¸·Ý

ÕâÁ½ÖÖ·½·¨ ¶¼Ìáʾ¡°¶ÔÊý¾Ý¿â¡°test_database¡±µÄ±¸·ÝÒԳɹ¦Íê³É¡±³É¹¦ÐÅÏ¢ÁË¡£
µ«ÊÇÔÚÎļþ¼ÐÖÐÕÒ²»µ½±¸·ÝÎļþ¡£ºÜÊÇÆæ¹Ö¡£¸ßÊÖÖ¸µã£¬Ð»À²


¿ìÈ¥ÕÒ°É

ÒýÓÃ
ÔÚÔ¶³Ì·þÎñÆ÷µÄcÅÌÏÂÃæ

Õý½â.


Ïà¹ØÎÊ´ð£º

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

ÈçºÎ°ÑmysqlÀïµÄÊý¾Ýµ¼Èëµ½sqlserverÀ

ÎÒÏë°ÑmysqlÀïµÄusers±íÀïÊý¾Ýµ¼Èëµ½sqlserverÀïµÄfs_me_users±íÀï
ÀïÃæµÄ×ֶξͲ»ÁгöÀ´ÁË ÊǶÔÓ¦µÃ¡£
ÓÃasp asp.net »òÕß Ö±½ÓsqlÓï¾ä¶¼ÐÐ
Çë½Ì¸÷λ¡£¡£¡£¡££¡
Õâ¸ö²»ÄѰÉ
1. asp.net µÄ»°,¶ÁÈ¡mysqlµÄ¼Ç¼¼¯ ......

¹ØÓÚSQLSERVER ²éѯµÄÎÊÌâ

´ó¼ÒºÃ ×î½üÓöµ½µãÂé·³ Çë´ó¼Ò°ïæ ÈçÏ £º

ÎÒÔÚÒ»¸öѧÉúµÄÊý¾Ý¿â STU ÖвéѯSTUDENTS ±íÖÐ Ïà¹ØµÄÊý¾Ý

CREATE TABLE STUDENTS
(
ID INT IDENTITY(1,1) PRIMARY KEY ,
[NAME] VARCHAR(20) N ......

¼±¼±¼±,SqlServerµÄÎÊÌâ

ÎÒÍùSqlServerÖмÓÊý¾ÝµÄʱºò,Ëû¸øÎÒ±¨Á˸ö´í
˵:"µ± IDENTITY_INSERT ÉèÖÃΪ OFF ʱ£¬²»ÄÜÏò±í 'O_TRAIN_CATEGORY' ÖеıêʶÁвåÈëÏÔʽֵ¡£"
ÒòΪÎÒÕâ¸ö±íµÄÖ÷¼üÉèÖõÄÊÇ×ÔÔöµÄ!ÊDz»ÊÇ×ÔÔöû¿ª°¡?Ôõô¸ ......

shell½Å±¾¶ÁÈ¡rrdÎļþ½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖÐ

ÓÃshell½Å±¾Ð´¸öС³ÌÐò£¬²»Í£µÄ¶ÁÈ¡rrdÎļþ£¬½«Êý¾Ý²åÈësqlserverÊý¾Ý¿âÖУ¬Çë¸ßÊÖ ½â´ð£¬ÔÚÏߵȣ¡£¡£¡

²»ÑÏÖØ£¬¿ÉÒÔ·ÃÎʱðµÄ·þÎñÆ÷µÄÊý¾Ý¿âÂð£¿

¸øÄãÒ»¸ö˼·£º
shell½Å±¾¶ÁÈ¡Îļþ£º¼ÙÉèÊý¾ÝÎļþÖÐÒ»ÐÐÊÇÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ