]]>
]]>
- 榪愯 Windows Server 2008 瀹夎紼嬪簭銆?
- 褰撴彁紺烘偍杈撳叆浜у搧瀵嗛挜榪涜嬋媧繪椂錛岃涓嶈杈撳叆涓涓瘑閽ャ?鍗曞嚮 鍚?錛屽綋瀹夎紼嬪簭瑕佹眰鎮ㄧ‘璁ゆ偍鐨勯夋嫨銆?
- 鍙兘浼氭彁紺烘偍閫夋嫨鐗堢殑 Windows Server 2008 瑕佽綆椼? 閫夋嫨瑕佸畨瑁呯殑鐗堟湰銆?
璇鋒敞鎰? 瀹夎 Windows Server 2008 鍚庯紝鐗堟湰涓嶈兘鏇存敼鑰屼笉閲嶆柊瀹夎涓? - 褰撶郴緇熸彁紺烘偍鏃惰闃呰 Microsoft 杞歡璁稿彲鏉℃涓殑鍦ㄨ瘎浼版潯嬈撅紝騫跺啀鎺ュ彈鍏舵潯嬈俱?
- 瀹屾垚 Windows Server 2008 瀹夎紼嬪簭鏃跺惎鍔紝鎮ㄧ殑鍒濆 60 澶╃殑璇勪及鏈熼檺銆? 鑻ヨ媯鏌ユ偍褰撳墠鐨勮瘎浼版湡涓婂墿浣欑殑鏃墮棿錛岃繍琛?Slmgr.vbs 鑴氭湰浣嶄簬 System 32 鏂囦歡澶逛腑鐨勩? 浣跨敤璇?-dli 寮鍏蟲潵榪愯姝よ剼鏈? slmgr.vbs dli 鍛戒護鏄劇ず澶勪簬褰撳墠鐨?60 澶╃殑璇勪及鏈熼棿涓殑澶╂暟銆?/li>
濡備綍鎵嬪姩鎵╁睍璇勪及鏈?
褰撳垵濮?60 澶╄瘯鐢ㄦ湡鎺ヨ繎鏈熬鏃訛紝鎮ㄥ彲浠ヨ繍琛?Slmgr.vbs 鑴氭湰鏉ラ噸緗瘎浼版湡銆? 瑕佽繖鏍峰仛錛岃鎸変笅鍒楁楠ゆ搷浣滐細- 鍗曞嚮 寮濮?錛岀劧鍚庡崟鍑? 鍛戒護鎻愮ず絎?銆?
- 閿叆 slmgr.vbs dli 錛岀劧鍚庢寜 ENTER 閿互媯鏌ユ偍鐨勮瘎浼版湡鐨勫綋鍓嶇姸鎬併?
- 瑕侀噸緗瘎浼版湡錛岃閿叆 slmgr.vbs –rearm 錛屽茍鎸?Enter 閿?
- 閲嶆柊鍚姩璁＄畻鏈恒?/li>
濡備綍鑷姩鍖栬瘎浼版湡鐨勬墿灞?/h3>
鍙互璁劇疆鑷姩閲嶇疆璇勪及鏈熸瘡 60 澶╃殑榪囩▼銆? 鑷姩鎵ц姝よ繃紼嬬殑涓縐嶆柟娉曟槸浣跨敤浠誨姟璁″垝紼嬪簭銆? 鎮ㄥ彲浠ラ厤緗換鍔¤鍒掔▼搴忚繍琛?Slmgr.vbs 鑴氭湰錛屼互鍙婂湪鐗瑰畾鏃墮棿閲嶆柊鍚姩鏈嶅姟鍣ㄣ? 瑕佽繖鏍峰仛錛岃鎸変笅鍒楁楠ゆ搷浣滐細
- 鍗曞嚮 寮濮?錛屾寚鍚? 綆＄悊宸ュ叿 錛岀劧鍚庡崟鍑? 浠誨姟璁″垝紼嬪簭 銆?/li>
- 灝嗕笅鍒楃ず渚嬩換鍔″鍒跺埌鏈嶅姟鍣紝鐒跺悗灝嗗叾淇濆瓨涓?xml 鏂囦歡銆? 鏄緥濡傚彲浠ュ皢璇ユ枃浠朵繚瀛樹負 Extend.xml 銆?
<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
<RegistrationInfo>
<Date>2007-09-17T14:26:04.433</Date>
<Author>Microsoft Corporation</Author>
</RegistrationInfo>
<Triggers>
<TimeTrigger id="18c4a453-d7aa-4647-916b-af0c3ea16a6b">
<Repetition>
<Interval>P31D</Interval>
<StopAtDurationEnd>false</StopAtDurationEnd>
</Repetition>
<StartBoundary>2007-10-05T02:23:24</StartBoundary>
<EndBoundary>2008-09-17T14:23:24.777</EndBoundary>
<Enabled>true</Enabled>
</TimeTrigger>
</Triggers>
<Principals>
<Principal id="Author">
<UserId>domain\alias</UserId>
<LogonType>Password</LogonType>
<RunLevel>HighestAvailable</RunLevel>
</Principal>
</Principals>
<Settings>
<IdleSettings>
<Duration>PT10M</Duration>
<WaitTimeout>PT1H</WaitTimeout>
<StopOnIdleEnd>true</StopOnIdleEnd>
<RestartOnIdle>false</RestartOnIdle>
</IdleSettings>
<MultipleInstancesPolicy>IgnoreNew</MultipleInstancesPolicy>
<DisallowStartIfOnBatteries>true</DisallowStartIfOnBatteries>
<StopIfGoingOnBatteries>true</StopIfGoingOnBatteries>
<AllowHardTerminate>true</AllowHardTerminate>
<StartWhenAvailable>false</StartWhenAvailable>
<RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
<AllowStartOnDemand>true</AllowStartOnDemand>
<Enabled>true</Enabled>
<Hidden>false</Hidden>
<RunOnlyIfIdle>false</RunOnlyIfIdle>
<WakeToRun>true</WakeToRun>
<ExecutionTimeLimit>P3D</ExecutionTimeLimit>
<DeleteExpiredTaskAfter>PT0S</DeleteExpiredTaskAfter>
<Priority>7</Priority>
<RestartOnFailure>
<Interval>PT1M</Interval>
<Count>3</Count>
</RestartOnFailure>
</Settings>
<Actions Context="Author">
<Exec>
<Command>C:\Windows\System32\slmgr.vbs</Command>
<Arguments>-rearm</Arguments>
</Exec>
<Exec>
<Command>C:\Windows\System32\shutdown.exe</Command>
<Arguments>/r</Arguments>
</Exec>
</Actions>
</Task>
- 鍦ㄧず渚嬩換鍔′腑鏇存敼浠ヤ笅鐨勭敤鎴?ID ” 鏍囪浠ュ寘鍚偍鐨勫煙鍜屾偍鐨勫埆鍚嶇殑鍊鹼細
<userid>domain\alias</UserId>
- 鍦ㄤ換鍔¤鍒掔▼搴忎腑鍗曞嚮 鎿嶄綔 鑿滃崟涓婄殑 瀵煎叆浠誨姟 銆?
- 鍗曞嚮紺轟緥浠誨姟.xml 鏂囦歡銆?渚嬪錛屽崟鍑? Extend.xml 銆?
- 鍗曞嚮 瀵煎叆 銆?
- 鍗曞嚮 瑙﹀彂鍣? 閫夐」鍗°?
- 鍗曞嚮 涓嬈? 瑙﹀彂鍣紝鐒跺悗鍗曞嚮 緙栬緫 銆?
- 鏇存敼鎮ㄥ綋鍓嶇殑璇勪及鏈熺粨鏉熶箣鍓嶅彧闇涓烘棩鏈熺殑浠誨姟寮濮嬫棩鏈熴?
- 鍗曞嚮 紜畾 錛岀劧鍚庨鍑轟換鍔¤鍒掔▼搴忋?
浠誨姟璁″垝紼嬪簭鐜板湪灝嗚繍琛岃瘎浼伴噸緗搷浣滃湪鎮ㄦ寚瀹氱殑鏃ユ湡銆? 
]]>
<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
<RegistrationInfo>
<Date>2007-09-17T14:26:04.433</Date>
<Author>Microsoft Corporation</Author>
</RegistrationInfo>
<Triggers>
<TimeTrigger id="18c4a453-d7aa-4647-916b-af0c3ea16a6b">
<Repetition>
<Interval>P31D</Interval>
<StopAtDurationEnd>false</StopAtDurationEnd>
</Repetition>
<StartBoundary>2007-10-05T02:23:24</StartBoundary>
<EndBoundary>2008-09-17T14:23:24.777</EndBoundary>
<Enabled>true</Enabled>
</TimeTrigger>
</Triggers>
<Principals>
<Principal id="Author">
<UserId>domain\alias</UserId>
<LogonType>Password</LogonType>
<RunLevel>HighestAvailable</RunLevel>
</Principal>
</Principals>
<Settings>
<IdleSettings>
<Duration>PT10M</Duration>
<WaitTimeout>PT1H</WaitTimeout>
<StopOnIdleEnd>true</StopOnIdleEnd>
<RestartOnIdle>false</RestartOnIdle>
</IdleSettings>
<MultipleInstancesPolicy>IgnoreNew</MultipleInstancesPolicy>
<DisallowStartIfOnBatteries>true</DisallowStartIfOnBatteries>
<StopIfGoingOnBatteries>true</StopIfGoingOnBatteries>
<AllowHardTerminate>true</AllowHardTerminate>
<StartWhenAvailable>false</StartWhenAvailable>
<RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
<AllowStartOnDemand>true</AllowStartOnDemand>
<Enabled>true</Enabled>
<Hidden>false</Hidden>
<RunOnlyIfIdle>false</RunOnlyIfIdle>
<WakeToRun>true</WakeToRun>
<ExecutionTimeLimit>P3D</ExecutionTimeLimit>
<DeleteExpiredTaskAfter>PT0S</DeleteExpiredTaskAfter>
<Priority>7</Priority>
<RestartOnFailure>
<Interval>PT1M</Interval>
<Count>3</Count>
</RestartOnFailure>
</Settings>
<Actions Context="Author">
<Exec>
<Command>C:\Windows\System32\slmgr.vbs</Command>
<Arguments>-rearm</Arguments>
</Exec>
<Exec>
<Command>C:\Windows\System32\shutdown.exe</Command>
<Arguments>/r</Arguments>
</Exec>
</Actions>
</Task>
<userid>domain\alias</UserId>
1 create or replace procedure search(v_colname in varchar2, v_find in varchar2) as
2 v_sql varchar2(2000);
3 v_result varchar2(1000);
4 v_cursor number;
5 v_stat number;
6 begin
7 dbms_output.put_line('琛ㄥ悕,鍒楀悕,緇撴灉');
8 for a in (select table_name,column_name from user_tab_columns where column_name = v_colname) loop
9 v_cursor := dbms_sql.open_cursor;
10 v_sql := 'select ' || v_colname || ' from ' || a.table_name || ' where ' || v_colname || ' like ''%' || v_find || '%''';
11 dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
12 dbms_sql.define_column(v_cursor,1,v_result,1000);
13 v_stat := dbms_sql.execute(v_cursor);
14 loop exit when dbms_sql.fetch_rows(v_cursor)<=0;
15 dbms_sql.column_value(v_cursor,1,v_result);
16 dbms_output.put_line(a.table_name||','||a.column_name||','||v_result);
17 end loop;
18 dbms_sql.close_cursor(v_cursor);
19 end loop;
20 end search;
21
2 v_sql varchar2(2000);
3 v_result varchar2(1000);
4 v_cursor number;
5 v_stat number;
6 begin
7 dbms_output.put_line('琛ㄥ悕,鍒楀悕,緇撴灉');
8 for a in (select table_name,column_name from user_tab_columns where column_name = v_colname) loop
9 v_cursor := dbms_sql.open_cursor;
10 v_sql := 'select ' || v_colname || ' from ' || a.table_name || ' where ' || v_colname || ' like ''%' || v_find || '%''';
11 dbms_sql.parse(v_cursor,v_sql,dbms_sql.native);
12 dbms_sql.define_column(v_cursor,1,v_result,1000);
13 v_stat := dbms_sql.execute(v_cursor);
14 loop exit when dbms_sql.fetch_rows(v_cursor)<=0;
15 dbms_sql.column_value(v_cursor,1,v_result);
16 dbms_output.put_line(a.table_name||','||a.column_name||','||v_result);
17 end loop;
18 dbms_sql.close_cursor(v_cursor);
19 end loop;
20 end search;
21
鍦╫racle 10g涓嬫祴璇曢氳繃.
浣跨敤鏂規硶:
begin search('...','...'); end;
/
絎竴涓弬鏁版槸鐭ラ亾鐨勫垪鍚?絎簩涓弬鏁版槸闇瑕佹煡鎵劇殑鏁版嵁
涓嬮潰鏄墽琛屾晥鏋?
1 SQL> begin search('絳旀','璇曢瑙勮寖'); end;
2 2 /
3
4 琛ㄥ悕,鍒楀悕,緇撴灉
5 鏁版嵁鍊肩瓟妗堣〃,絳旀,闈㈣瘯璇曢瑙勮寖銆?br> 6 鏁版嵁鍊肩瓟妗堣〃,絳旀,榪涗竴姝ュ畬鍠勯潰璇曡瘯棰樿鑼冦?br> 7 鏁版嵁鍊肩瓟妗堣〃,絳旀,淇敼鑰冩牳璇曢瑙勮寖銆?br> 8 鏁版嵁鍊肩瓟妗堣〃,絳旀,榪涗竴姝ュ畬鍠勮冩牳璇曢瑙勮寖銆?br> 9 鏁版嵁鍊肩瓟妗堣〃,絳旀,鑰冩牳璇曢瑙勮寖鏈夎銆?br>10 鏁版嵁鍊肩瓟妗堣〃,絳旀,淇敼鑰冩牳楂樼駭璇曢瑙勮寖銆?br>11 鏁版嵁鍊肩瓟妗堣〃,絳旀,鑰冩牳楂樼駭璇曢瑙勮寖蹇熷垎欏佃鑼冿紝淇敼閿欒欏甸潰銆?/span>
2 2 /
3
4 琛ㄥ悕,鍒楀悕,緇撴灉
5 鏁版嵁鍊肩瓟妗堣〃,絳旀,闈㈣瘯璇曢瑙勮寖銆?br> 6 鏁版嵁鍊肩瓟妗堣〃,絳旀,榪涗竴姝ュ畬鍠勯潰璇曡瘯棰樿鑼冦?br> 7 鏁版嵁鍊肩瓟妗堣〃,絳旀,淇敼鑰冩牳璇曢瑙勮寖銆?br> 8 鏁版嵁鍊肩瓟妗堣〃,絳旀,榪涗竴姝ュ畬鍠勮冩牳璇曢瑙勮寖銆?br> 9 鏁版嵁鍊肩瓟妗堣〃,絳旀,鑰冩牳璇曢瑙勮寖鏈夎銆?br>10 鏁版嵁鍊肩瓟妗堣〃,絳旀,淇敼鑰冩牳楂樼駭璇曢瑙勮寖銆?br>11 鏁版嵁鍊肩瓟妗堣〃,絳旀,鑰冩牳楂樼駭璇曢瑙勮寖蹇熷垎欏佃鑼冿紝淇敼閿欒欏甸潰銆?/span>
]]>
]]>
]]>
]]>
]]>
]]>
TQ: http://www.embedsky.net/bbs/
csdn: http://www.csdn.net
cppblog: http://www.shnenglu.com
vckbase: http://www.vckbase.com
msdn: http://msdn.microsoft.com
codeproject: http://www.codeproject.com
codeguru: http://www.codeguru.com
multi-platform: http://freshmeat.net/
鐢靛獎綾?br>
csdn: http://www.csdn.net
cppblog: http://www.shnenglu.com
vckbase: http://www.vckbase.com
msdn: http://msdn.microsoft.com
codeproject: http://www.codeproject.com
codeguru: http://www.codeguru.com
multi-platform: http://freshmeat.net/
鐢甸┐: http://www.verycd.com/
榪呴浄鐢靛獎: http://bbs.xldy.cn/
鐙楃嫍褰辮: http://movie.gougou.com/
btchina: http://www.btchina.net/
鍦熻眴緗? http://www.tudou.com/
浼橀叿: http://www.youku.com/
WAF: http://www.waf.com.cn/bbs/
33md: http://www.33md.com/
榪呴浄鐢靛獎: http://bbs.xldy.cn/
鐙楃嫍褰辮: http://movie.gougou.com/
btchina: http://www.btchina.net/
鍦熻眴緗? http://www.tudou.com/
浼橀叿: http://www.youku.com/
WAF: http://www.waf.com.cn/bbs/
33md: http://www.33md.com/
鎰熻阿Popzys鐨勬敮鎸?
甯哥敤杞歡涓嬭澆緗戯細
http://www.greendown.cn/default.html 緇胯壊涓嬭澆緗?br>http://download.gobee.cn/ 楂樻瘮杞歡緗?br>http://www.pc0359.cn/ 緗戝惂杞歡涓嬭澆
甯哥敤灝忚緗戯細
褰辮緗?br>
http://www.xinxl.com/ 璁浄緇艱壓涓嬭澆緗?br>http://www.shooter.com.cn/ 灝勬墜緗?br>
璁哄潧
http://www.wlanbbs.com/index.php 涓浗鏃犵嚎璁哄潧
澶╂皵緗?br>
鍦ㄧ嚎鏌ユ瘨緗?br> 嬈㈣繋澶у鍥炲笘鎷嶇爾,鎸佺畫鏇存柊涓?br>
]]>