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

ÇåÀíSQLÈÕÖ¾µÄ·½·¨

 ÊÖ¶¯ÇåÀí
1¡¢´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁîDUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
2¡¢ÔÙ´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üÄãҪѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁ: ,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,Ö±½ÓÊäÈëÕâ¸öÊý,È·¶¨¾Í¿ÉÒÔÁË¡£
Èç1)
×Ô¶¯ÇåÀí
ÆóÒµ¹ÜÀíÆ÷-¡·¹ÜÀí-¡·sql   server´úÀí(ÒªÆô¶¯·þÎñ)-¡·×÷Òµ  
   
  н¨Ò»¸ö×÷ÒµÖ´ÐÐSQLÓï¾ä£º  
  Çå¿ÕÈÕÖ¾£º  
  DUMP   TRANSACTION   '¿âÃû'   WITH   NO_LOG  
   
  DBCC   SHRINKFILE(   'ÈÕÖ¾ÎļþÃû',еĴóСÊýÖµÐÍÈç1)


Ïà¹ØÎĵµ£º

ms sql ¸üбíAÖÐijÁÐΪ±íBÖеÄÖµ


ms sql ¸üбíAÖÐijÁÐΪ±íBÖеÄÖµ
select *
from dbo.NT_areapin
go
select *
from dbo.NT_dict_area
update NT_areapin
set AllNamePin='PengShui'
from NT_areapin
where AreaId='486'
go
update NT_dict_area
set BriefNamePin = NT_areapin.BriefNamePin,AllNamePin = NT_areapin.AllNamePin
from N ......

SQL´æ´¢¹ý³Ì»ù´¡Óï·¨Ö®Ò»

 CREATE PROCEDURE
´´½¨´æ´¢¹ý³Ì£¬´æ´¢¹ý³ÌÊDZ£´æÆðÀ´µÄ¿ÉÒÔ½ÓÊܺͷµ»ØÓû§ÌṩµÄ²ÎÊýµÄ Transact-SQL Óï¾äµÄ¼¯ºÏ¡£
¿ÉÒÔ´´½¨Ò»¸ö¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°ÖÐÁÙʱʹÓ㨾ֲ¿ÁÙʱ¹ý³Ì£©£¬»òÔÚËùÓлỰÖÐÁÙʱʹÓã¨È«¾ÖÁÙʱ¹ý³Ì£©¡£Ò²¿ÉÒÔ´´½¨ÔÚ Microsoft? SQL Server? Æô¶¯Ê±×Ô¶¯ÔËÐеĴ洢¹ý³Ì¡£
Óï·¨
CREATE ......

SqlÐÔÄÜÓÅ»¯

 
²Ù×÷·ûÓÅ»¯
IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ×¶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵쬴ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³ ......

IISÓëSQL·þÎñÆ÷°²È«¼Ó¹ÌÏê½â(ת)

 
IIS Web·þÎñÆ÷°²È«¼Ó¹Ì²½Ö裺
²½Öè¡¡°²×°ºÍÅäÖà Windows Server 2003¡£
×¢Ò⣺
1.½«\System32\cmd.exe×ªÒÆµ½ÆäËûĿ¼»ò¸üÃû£»
2.ϵͳÕʺž¡Á¿ÉÙ£¬¸ü¸ÄĬÈÏÕÊ»§Ãû£¨ÈçAdministrator£©ºÍÃèÊö£¬ÃÜÂ뾡Á¿¸´ÔÓ£»
3.¾Ü¾øÍ¨¹ýÍøÂç·ÃÎʸüÆËã»ú£¨ÄäÃûµÇ¼£»ÄÚÖùÜÀíÔ±ÕÊ»§£»Support_388945a0£»Guest£»ËùÓзDzÙ×÷ϵͳ·þ ......

Oracle SQL TraceʹÓÃʵÀý

ΪÁËÑо¿Ò»ÏÂϵͳÔÚºǫ́¶¼¸ÉÁËʲô£¬µ±È»ÊÇÎÒÔÚ´úÂëÀïûÕÒµ½µÄÇé¿öÏ£¬Ñо¿ÁËÒ»ÏÂtrace£¬½á¹ûÓÐÒ»¶¨µÄ°ïÖú¡£oracleÖв»Ïñsql serverÖÐÄÇÑùÖ±½ÓÌṩͼÏñ»¯µÄ¹¤¾ß£¬ËùÒÔ»¹ÊǵÃ×Ô¼º¶¯ÊÖÀ´×ö£¬¹éÄÉÁËһϣ¬²½ÖèÈçÏ£º
²éѯsession£º
SQL> select sid, serial#, username from v$session where username='XXX';//ÕÒ³öÄãÒª¸ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ