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

asp.net(C#)ʵÏÖSQL2000Êý¾Ý¿â±¸·ÝºÍ»¹Ô­

asp.net(C#)ʵÏÖSQL2000Êý¾Ý¿â±¸·ÝºÍ»¹Ô­
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class databasemanager : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    /// <summary>
    /// Êý¾Ý¿â»Ö¸´ºÍ±¸·Ý
    /// </summary>
  
        #region SQLÊý¾Ý¿â±¸·Ý
        /// <summary>
        /// SQLÊý¾Ý¿â±¸·Ý
        /// </summary>
        /// <param name="ServerIP">SQL·þÎñÆ÷IP»ò(Localhost)</param>
        /// <param name="LoginName">Êý¾Ý¿âµÇ¼Ãû</param>
        /// <param name="LoginPass">Êý¾Ý¿âµÇ¼ÃÜÂë</param>
        /// <param name="DBName">Êý¾Ý¿âÃû</param>
        /// <param name="BackPath">±¸·Ýµ½µÄ·¾¶</param>
        public static void SQLBACK(string ServerIP, string LoginName, string LoginPass, string DBName, string BackPath)
        {
            SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
            SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
            try
           


Ïà¹ØÎĵµ£º

SQL Server 2008¶¨Ê±×÷ÒµµÄÖÆ¶¨£¨SQL2005²Î¿¼´Ë·½·¨£©

SQL Server 2008 ¶¨Ê±×÷ÒµµÄÖÆ¶¨
--1.´ò¿ª¡¾SQL Server Management Studio¡¿£¬ÔÚ¡¾¶ÔÏó×ÊÔ´¹ÜÀíÆ÷¡¿ÁбíÖÐÑ¡Ôñ¡¾SQL Server ´úÀí¡¿£»
--2.Êó±êÓÒ»÷¡¾SQL Server ´úÀí¡¿£¬Ñ¡Ôñ¡¾Æô¶¯(S)¡¿£¬ÈçÒÑÆô¶¯£¬¿ÉÒÔÊ¡ÂԴ˲½Ö裻
--3.Õ¹¿ª¡¾SQL Server ´úÀí¡¿ÁÐ±í£¬ÓÒ»÷¡¾×÷Òµ¡¿-->¡¾Ð½¨×÷Òµ¡¿£»
--3.1 ÔÚ¡¾³£¹æ¡¿Ñ¡ÏÖУº ......

MySQLºÍSQL×ֶνضÌ©¶´

×ªÔØ×Ô£ºhttp://www.neatstudio.com/index-4.shtml
ÎÄÕÂÀ´×Ô¼Åįhacker,http://hi.baidu.com/isbx/blog/item
/08ef48547ef1ad58574e00bf.html:
µ±Ç°µÄWeb¿ª·¢ÕßÖп϶¨Óв»ÉÙÈËûÓÐ×¢Òâµ½×÷ÕßËùÌáµ½µÄÕâÁ½¸öÎÊÌâµÄ¡£
µÚÒ»¸öÎÊÌâÊÇÕâÑùµÄ£¬MySQLĬÈÏÓÐÒ»¸öÅäÖòÎÊý
max_packet_size£¬Õâ¸ö²ÎÊýÊÇÓÃÓÚÏÞÖÆMySQL¿Í»§¶ËºÍMy ......

SQL Server 2008 ¶¨Ê±×÷Òµ

--SQL Server 2008 ¶¨Ê±×÷ÒµµÄÖÆ¶¨
--1.´ò¿ª¡¾SQL Server Management Studio¡¿£¬ÔÚ¡¾¶ÔÏó×ÊÔ´¹ÜÀíÆ÷¡¿ÁбíÖÐÑ¡Ôñ¡¾SQL Server ´úÀí¡¿£»
--2.Êó±êÓÒ»÷¡¾SQL Server ´úÀí¡¿£¬Ñ¡Ôñ¡¾Æô¶¯(S)¡¿£¬ÈçÒÑÆô¶¯£¬¿ÉÒÔÊ¡ÂԴ˲½Ö裻
--3.Õ¹¿ª¡¾SQL Server ´úÀí¡¿ÁÐ±í£¬ÓÒ»÷¡¾×÷Òµ¡¿-->¡¾Ð½¨×÷Òµ¡¿£»
--3.1  ÔÚ¡¾³£¹æ¡¿Ñ¡Ïî ......

SQL VIEW£¨ÊÓͼ£©


ÊÓͼÊÇ¿ÉÊÓ»¯µÄ±í¡£
±¾Õ½²½âÈçºÎ´´½¨¡¢¸üкÍɾ³ýÊÓͼ¡£
SQL CREATE VIEW Óï¾ä
ʲôÊÇÊÓͼ£¿
ÔÚ SQL ÖУ¬ÊÓͼÊÇ»ùÓÚ SQL Óï¾äµÄ½á¹û¼¯µÄ¿ÉÊÓ»¯µÄ±í¡£
ÊÓͼ°üº¬ÐкÍÁУ¬¾ÍÏñÒ»¸öÕæÊµµÄ±í¡£ÊÓͼÖеÄ×ֶξÍÊÇÀ´×ÔÒ»¸ö»ò¶à¸öÊý¾Ý¿âÖеÄÕæÊµµÄ±íÖеÄ×ֶΡ£ÎÒÃÇ¿ÉÒÔÏòÊÓͼÌí¼Ó SQL º¯Êý¡¢WHERE ÒÔ¼° JOIN Óï¾ä£¬ÎÒÃÇÒ²¿ÉÒ ......

SQL SERVER2005°æ±¾±È½Ï

ÔÚwindows XP SP3 ÖÐÊÇ¿ÉÒÔ°²×° SQL Server 2005 µÄ²»»áÓмæÈÝÎÊÌâ ÎÒÔÚ°²×°µÄʱºò¾ÍʲôÎÊÌⶼû¿´µ½ °²×°ºÃºó¸½¼ÓÒ»¸öÊý¾Ý¿â ÓÃBorland JBuilder 2006 Enterprise ºÍeclipse ҲûÎÊÌâ
SQL2005 ·ÖÎå¸ö°æ±¾£¬ÈçÏÂËùÁУ¬
¡¡¡¡1.Enterprise(ÆóÒµ°æ),
  2.Development(¿ª·¢°æ),
¡¡¡¡3.Workgroup,(¹¤×÷Ⱥ°æ)
¡¡¡¡4.St ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ