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

±¸·ÝºÍ»¹Ô­SQL Server¼°Ñ¹ËõAccessÊý¾Ý¿â

*
 * ¹¦ÄÜ˵Ã÷:±¸·ÝºÍ»Ö¸´SQL ServerÊý¾Ý¿â
 * ×÷Õß: Áõ¹¦Ñ«;
 * °æ±¾:V0.1(C#2.0);ʱ¼ä:2007-1-1
 * µ±Ê¹ÓÃSQL Serverʱ,ÇëÒýÓà COM×é¼þÖеÄ,SQLDMO.dll×é¼þ
 * µ±Ê¹ÓÃAccessÖÐ,Çëä¯ÀÀÌí¼ÓÒýÓÃÒÔÏÂÁ½¸ödll
 *          ÒýÓÃC:/Program Files/Common Files/System/ado/msadox.dll,¸ÃDLL°üº¬ADOXÃüÃû¿Õ¼ä
 *          ÒýÓÃC:/Program Files/Common Files/System/ado/msjro.dll,¸ÃDLL°üº¬JROÃüÃû¿Õ¼ä
 * *******************************************************************************/
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using ADOX;//¸ÃÃüÃû¿Õ¼ä°üº¬´´½¨ACCESSµÄÀà(·½·¨)--½â¾ö·½°¸ ==> ÒýÓà ==> Ìí¼ÓÒýÓà ==> ÓÎÀÀÕÒµ½.dll
using JRO;//¸ÃÃüÃû¿Õ¼ä°üº¬Ñ¹ËõACCESSµÄÀà(·½·¨)
namespace EC
{
    /// <summary>
    /// Êý¾Ý¿â»Ö¸´ºÍ±¸·Ý
    /// </summary>
    public class SqlBackObject
    {
        public SqlBackObject()
        {
            //
            // TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
            //
        }
        #region SQLÊý¾Ý¿â±¸·Ý
       /// <summary>
        /// SQLÊý¾Ý¿â±¸·Ý
       /// </summary>
       /// <param name="ServerIP">SQL·þÎñÆ÷IP»ò(Localhost)</param>
    


Ïà¹ØÎĵµ£º

SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ) ¹ØÓÚÖÐÎÄ·Ö´Ê


SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ)-¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:32:01)
תÔØ
 
·ÖÀࣺÉî¶ÈÑо¿
ÔÚʹÓÃSQL SearchµÄ¹ý³ÌÖУ¬»¹·¢ÏÖÁËÒ»¸öÎÊÌ⣺Ëü¶ÔÖÐÎÄ£¬ÊÇ°´×ִַʵģ¬ÏÂÃæÎÒ½âÊÍһϣº
±ÈÈç¶Ô'²©¿ÍÌóÉÔ±ºÜ¶àÊÇMVP'Õâ¾ä»°£¬¼ÙÈçÒ»¸ö¸öµÄ×ÖµÄ×÷Ë÷Òý£¬»á±ÈʹÓÃ'²©¿ÍÌÃ','³ÉÔ±',MVP'¼¸¸ö´Ê×÷Ë÷ÒýÉú³ÉµÄË ......

SQL ServerÈÕÆÚ

---Ò»¸öÔµĵÚÒ»Ìì
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) 
--- ±¾ÖܵÄÐÇÆÚÒ»
SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)
---Ò»ÄêµÄµÚÒ»Ìì
SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
----¼¾¶ÈµÄµÚÒ»Ìì
SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)
----ÉϸöÔµÄ×îºóÒ»Ìì
......

SQL Serverº¯Êý´óÈ«

--¾ÛºÏº¯Êý
use pubs
go
select avg(distinct price)  --Ëãƽ¾ùÊý
from titles
where type='business'
go 
use pubs
go
select max(ytd_sales)  --×î´óÊý
from titles
go 
use pubs
go
select min(ytd_sales) --×îÐ¡Ê ......

OracleÖÐSQL PLUSµÄ³£ÓÃÖ¸Áî

½øÈësql*plusÐèÒªÊäÈëÓû§Ãû¡¢¿ÚÁîºÍÖ÷»ú±êÖ¾·û
system/manager
sys/change_on_intall
scott/tiger
internal/oracle
ÒÔÉÏΪ³õʼÃÜÂë
Ö÷»ú×Ö·û´®¿Õ»òÕßÊÇ@+ÄãµÄ·þÎñÃû,ÔÚ±¾µØµÇ½²»ÐèÒª±¾µØ·þÎñÃû¡£
ÏÂÃæ¾Í½éÉÜÒ»ÏÂһЩ³£ÓõÄsql*plusÃüÁ
Ê×ÏȲ鿴µ±Ç°Ê¹ÓõÄÊý¾Ý¿âʵÀý:
select name from V$database;
Çл»Á½¸ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ