sqlserver Êý¾Ý¿â±¸·ÝÎÊÌâ
ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£
µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database.bak'
µÚ¶þÖÖ·½·¨£º
Ñ¡ÔñÊý¾Ý-ÈÎÎñ-±¸·Ý
ÕâÁ½ÖÖ·½·¨ ¶¼Ìáʾ¡°¶ÔÊý¾Ý¿â¡°test_database¡±µÄ±¸·ÝÒԳɹ¦Íê³É¡±³É¹¦ÐÅÏ¢ÁË¡£
µ«ÊÇÔÚÎļþ¼ÐÖÐÕÒ²»µ½±¸·ÝÎļþ¡£ºÜÊÇÆæ¹Ö¡£¸ßÊÖÖ¸µã£¬Ð»À²
¿ìÈ¥ÕÒ°É
Õý½â.
Ïà¹ØÎÊ´ð£º
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......
±êÌâ: Á¬½Óµ½·þÎñÆ÷
------------------------------
ÎÞ·¨Á¬½Óµ½ LIJINING-PC¡£
------------------------------
ÆäËûÐÅÏ¢:
Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼ¹ý³ÌÖз¢Éú´íÎó¡£ (provider: ¹²ÏíÄÚ´æÌṩ³ÌÐò, ......
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......
ÎÒÍùSqlServerÖмÓÊý¾ÝµÄʱºò,Ëû¸øÎÒ±¨Á˸ö´í
˵:"µ± IDENTITY_INSERT ÉèÖÃΪ OFF ʱ£¬²»ÄÜÏò±í 'O_TRAIN_CATEGORY' ÖеıêʶÁвåÈëÏÔʽֵ¡£"
ÒòΪÎÒÕâ¸ö±íµÄÖ÷¼üÉèÖõÄÊÇ×ÔÔöµÄ!ÊDz»ÊÇ×ÔÔöû¿ª°¡?Ôõô¸ ......