¶¨ÆÚɾ³ý±¸·ÝµÄSQLÊý¾Ý¿âµÄ½Å±¾
±ÈÈçij¸öÊý¾Ý¿â϶ÔSQL SERVERµÄÊý¾Ý¿â½øÐÐÁËÿÌìµÄ±¸·Ý£¬ÏÖÔÚÒª±£Áô7ÌìÒÔÄڵ쬯äËûµÄɾ³ýµô£¬ÓÃASP¿ÉÒÔʵÏÖÁË£¬µ«ÒªÓõ½filesystemobject£¬²»´óˬ
Ê×ÏÈдһ¸öjsÎļþclearDatabaseBackup£¬ÄÚÈÝÈçÏÂ
function deleteBackupFile(beforedays) {
var fso = new ActiveXObject("Scripting.FileSystemObject");
var dir = fso.GetFolder("D:\\Êý¾Ý¿â±¸·Ý"); //¸Ä³ÉÄãµÄÊý¾Ý¿â±¸·ÝĿ¼
for (var fc = new Enumerator(dir.SubFolders); !fc.atEnd(); fc.moveNext()) {
//¼ÙÉèÊý¾ÝÎļþµÄ±¸·ÝÎļþ¶¼ÊÇÒÔabc_log¿ªÍ·µÄ£¬±ÈÈçabc_log_xxxx
if (fc.item().name.substr(0,9) == "abc_log") {
for (var logfiles = new Enumerator(fc.item().Files); !logfiles.atEnd(); logfiles.moveNext()) {
var fileName = logfiles.item().name;
var year = "20" + fileName.substr(19, 2);
var month = fileName.substr(21, 2);
var day = fileName.substr(23, 2);
var days = Math.round(((new Date()).getTime() - Date.UTC(year, month - 1, day)) / 1000 / 60 / 60 / 24);
if (days >= beforedays) logfiles.item().Delete();
}
}
}
}
//±£´æÒ»ÖÜÄÚµÄÊý¾Ý¿â±¸·ÝÎļþ
deleteBackupFile(7);
È»ºóдһ¸öBATÎļþ£¬¼ÓÈëµ½ÈÎÎñ¼Æ»®
cscript clearDatabaseBackup.js
Ïà¹ØÎĵµ£º
Ò».Ãû´Ê½âÊÍ£º
0¡£SQL ½á¹¹»¯²éѯÓïÑÔ(Structured Query Language)
1¡£·Ç¹ØÏµÐÍÊý¾Ý¿âϵͳ
×öΪµÚÒ»´úÊý¾Ý¿âϵͳµÄ×ܳƣ¬Æä°üÀ¨2ÖÖÀàÐÍ£º“²ã´Î”Êý¾Ý¿âÓë“Íø×´”Êý¾Ý¿â
“²ã´Î”Êý¾Ý¿â¹ÜÀíϵͳ eg:IBM&IMS (Information Management System ......
1¡¢ Ç¿´óµÄgroup by
1 select stdname,2 isnull(sum( case stdsubject when ' »¯Ñ§ ' then Result end), 0 ) [»¯Ñ§],3 isnull(sum( case stdsubject when ' Êýѧ ' then Result end), 0 ) [Êýѧ],4 isnull(sum( case stdsubject when ' ÎïÀí ' then Result end), 0 ) [ÎïÀí],5 isnull(sum( case stdsubject when ' ÓïÎÄ ' t ......
SQL SERVER 2005 ͬ²½¸´ÖƼ¼Êõ
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......
BCPÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB-LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£
/********************************************************
ÀýÈ磺
´Ó±¾µØ·þÎñÆ÷ÖУ¨ÓÐÓû§ÃûºÍÃÜÂ룩µ¼³ötxtÎı¾
EXEC master..xp_cmdshell 'bcp "select * from pubs..authors" queryou ......
SQL ServerÁ¬½ÓÔ¶³ÌÊý¾ÝÔ´µÄ»ù±¾·½·¨ÓÐÏÂÃæÈýÖÖ£º
OPENDATASOURCE: The OPENDATASOURCE function is used to specify connection information for a remote data source by specifying the OLE DB provider and an initialization string. OPENDATASOURCE can be used directly within a SELECT, INSERT, UPDATE, or DELET ......