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

¶¨ÆÚɾ³ý±¸·ÝµÄ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


Ïà¹ØÎĵµ£º

SQL²éѯÐÔÄÜÓÅ»¯

Ò».Ãû´Ê½âÊÍ£º
0¡£SQL ½á¹¹»¯²éѯÓïÑÔ(Structured Query Language)
1¡£·Ç¹ØÏµÐÍÊý¾Ý¿âϵͳ
×öΪµÚÒ»´úÊý¾Ý¿âϵͳµÄ×ܳƣ¬Æä°üÀ¨2ÖÖÀàÐÍ£º“²ã´Î”Êý¾Ý¿âÓë“Íø×´”Êý¾Ý¿â
“²ã´Î”Êý¾Ý¿â¹ÜÀíϵͳ eg:IBM&IMS (Information Management System ......

sql ÐÐתÁÐ

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 ͬ²½¸´ÖƼ¼Êõ
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀ ......

ÓÃBCP´ÓSQL ServerÖе¼³ötxtÎı¾

BCPÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB-LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£
/********************************************************
ÀýÈ磺
´Ó±¾µØ·þÎñÆ÷ÖУ¨ÓÐÓû§ÃûºÍÃÜÂ룩µ¼³ötxtÎı¾
EXEC master..xp_cmdshell 'bcp "select * from pubs..authors" queryou ......

SQL ServerÁ¬½ÓÔ¶³ÌÊý¾ÝÔ´µÄ»ù±¾·½·¨

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ