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

SQL SERVERÒìµØ±¸·Ý·½·¨(1)

д³É´æ´¢¹ý³Ì£¬½¨Á¢×÷Òµ¶¨Ê±±¸·Ý~~~
--ÔÚsqlÖÐÓ³ÉäһϾͿÉÒÔÁË
exec master..xp_cmdshell 'net use z: \\yizhi\D$ "ÃÜÂë" /user:yizhi\administrator'
/*--˵Ã÷:
exec master..xp_cmdshell 'net use z: \\xz\c$ "ÃÜÂë" /user:xz\administrator'
z:ÊÇÓ³ÉäÍøÂç·¾¶¶ÔÓ¦±¾»úµÄÅÌ·û,ÓëÏÂÃæµÄ±¸·Ý¶ÔÓ¦
\\xz\c$ÊÇÒªÓ³ÉäµÄÍøÂç·¾¶
xz\administrator
xzÊÇÔ¶³ÌµÄ¼ÆËã»úÃû,
administratorÊǵǽµÄÓû§Ãû
ÃÜÂë ÃæÖ¸¶¨µÄadministratorÓû§µÄÃÜÂë
--*/
--±¸·Ý£»with init¸²¸Ç|noinitÌí¼Ó
backup database ¿âÃû to disk='E:\H_BACKUP.bak' with init
--COPY
exec master..xp_cmdshell 'copy E:\H_BACKUP.bak z:'
--ɾ³ý£¨Õâ¾ä¿ÉÒÔÈ¥µô£©
--exec master..xp_cmdshell 'del E:\H_BACKUP.bak'
--Íê³Éºóɾ³ýÓ³Éä
exec master..xp_cmdshell 'net use z: /delete'


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......

SQL SERVERÈçºÎ¼õÉÙËÀËø

 Ö÷ÒªÕë¶ÔSQL ServerÊý¾Ý¿âËÀËøÏÖÏóµÄÔ¤·À¼°½â¾ö´ëÊ©½øÐÐÁËÏêϸµÄ½éÉÜ£¬¸ü¶àÄÚÈÝÇë´ó¼Ò²Î¿¼ÏÂÎÄ£º
¡¡¡¡ËÀËøÊÇÖ¸ÔÚij×é×ÊÔ´ÖУ¬Á½¸ö»òÁ½¸öÒÔÉϵÄÏß³ÌÔÚÖ´Ðйý³ÌÖУ¬ÔÚÕù¶áijһ×ÊԴʱ¶øÔì³É»¥ÏàµÈ´ýµÄÏÖÏó£¬ÈôÎÞÍâÁ¦µÄ×÷ÓÃÏÂ,ËüÃǶ¼½«ÎÞ·¨ÍƽøÏÂÈ¥£¬ËÀʱ¾Í¿ÉÄÜ»á²úÉúËÀËø,ÕâЩÓÀÔ¶ÔÚ»¥ÏàµÈ´ýµÄ½ø³Ì³ÆÎªËÀËøÏ̡߳£¼òµ¥µ ......

¹ØÓÚ sql server ÊÓͼ

    Ôø¾­ÓÐÏëͨ¹ý´´½¨sql serverÊÓͼµ÷ÕûÓ¦ÓÃÐÔÄܵÄÏë·¨£¬²»¹ýºóÀ´Ö¤Ã÷Õâ¸öÏë·¨ÊÇÐв»Í¨µÄ¡£
    ×öÁ˸öʵÑ飬ÔÚ¶ÔÔ­À´µÄsqlÓï¾äµ÷ÕûÖ®ºó´´½¨ÁËÁ½¸öÊÓͼ£¬°ÑÔ­À´µÄsqlת»»ÎªÊÓͼÁË£¬Í¨¹ýÊÓͼÀ´¶ÁÈ¡Êý¾Ý¡£×îÖյıȽϽá¹ûÊÇͨ¹ýÊÓͼ±ÈÖ±½ÓʹÓÃsqlÓï¾äÒªÂý£¬Í¨¹ýÊÓͼÀ´Ìá¸ßsqlµÄÐÔÄÜ¿´À´ÊDz»ÐÐ ......

ä¯ÀÀLINQ to SQL¹ØÏµ

±êÇ©£ºÊý¾Ý·ÃÎÊ     LINQ     LINQ to SQL ²¿·Ö
ä¯ÀÀLINQ to SQL¹ØÏµ      Á½¸ö¹ØÁªµÄ±í£º
 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ