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

SQL 2005 °²×°

ÏÂÔØsql2005ÍêÒÔºó½âѹ³öÀ´£¬´ó¼Ò¿ÉÒÔ¿´µ½cs_sql_2005_chs_x86Õâ¸öĿ¼£¬½øÈëÕâ¸öĿ¼ÔËÐÐsetup.exeÎļþ£¬°²×°³ÌÐò¾Í¿ªÊ¼ÔËÐÐÁË¡£
Ê×Ïȵ¯³öÀ´µÄÊÇÈí¼þÐí¿ÉÌõ¿î
¹´ÉÏÎÒ½Ó°®Ðí¿ÉÌõ¿îºÍÌõ¼þ£¬µãÏÂÒ»²½
ÕâÀïÁгöÁËSQL2005ÔËÐл·¾³£¬Ö±½Óµã°²×°
³ÌÐò¿ªÊ¼°²×°SQL2005ÔËÐбØÐèµÄ»·¾³£¬ÅäÖÃ×é¼þ
±ØÐèµÄ×é¼þ°²×°ºÃÁË£¬µãÏÂÒ»²½¼ÌÐø°²×°
³ÌÐò¼ì²é°²×°»úÆ÷µÄÅäÖ㬵ãÏÂÒ»²½¼ÌÐø°²×°
³ÌÐò¼ì²â¸÷ÖÖ°²×°±ØÐèµÄ»·¾³£¬¶¼Í¨¹ýÁ˾ͿÉÒÔÖ±½ÓµãÏÂÒ»²½¼ÌÐø°²×°ÁË
°²×°³ÌÐòÒѾ­¼¯³ÉÁËCDKEY£¬Ö±½ÓµãÏÂÒ»²½¼ÌÐø°²×°
Ñ¡ÔñÒª°²×°µÄ×é¼þ£¬Õâ¾Í¿´Ã¿¸öÈ˵ÄÐèÒªÁË£¬µÚÒ»ÏîÊý¾Ý¿â·þÎñÆ÷Êǿ϶¨Òª°²×°µÄ£¬ÆäËü¿ÉÒÔ¿´¸÷ÈËÐèÇ󣬰ÑÒª°²×°µÄ¹´ÉÏ£¬µãÏÂÒ»²½¼ÌÐø°²×°£¬Ò²¿ÉÒÔµã¸ß¼¶½øÈëÏêϸ°²×°Ñ¡Ïî
ÕâÀï¸úÇ°ÃæÒ»²½²î²»¶à£¬Ö»ÊÇÕâЩµÄÑ¡Ïî¸üÏêϸ£¬Ñ¡ºÃÒÔºóµãÏÂÒ»²½¼ÌÐø°²×°
ÕâÀïÊÇÑ¡ÔñʵÀýÃû£¬Ò»°ã¾ÍÊÇÖ±½ÓÓÃĬÈÏ£¬ÓÐÐèÒªµÄ¿ÉÒÔ×Ô¼ºÉèÖã¬ÉèÖúõãÏÂÒ»²½
ÕâÀïÑ¡Ôñ·þÎñÆô¶¯Óõ½µÄÕË»§£¬Ò»°ãÊÇÓñ¾µØÏµÍ³Õ˺ţ¬ÏÂÃæÊÇÑ¡Ôñ°²×°ºÃÒªÆô¶¯ÄÄЩ·þÎñ£¬°´×Ô¼ºÐèҪѡÔñ£¬Ñ¡ºÃµãÏÂÒ»²½¼ÌÐø°²×°
ÕâÀïÊÇÉèÖÃÊý¾Ý¿âµÄÉí·ÝÑé֤ģʽ£¬Ò»°ãÊÇÓûìºÏģʽ£¬ÔÙ¸øSAÉèÖÃÒ»¸öÃÜÂ룬µãÏÂÒ»²½¼ÌÐø°²×°
ÕâÀïÊÇÑ¡ÔñÊý¾Ý¿âÅÅÐò¹æÔòÉèÖã¬Ò»°ãÊÇÖ±½ÓĬÈϾÍÐÐÁË£¬µãÏÂÒ»²½
ÕâÀïÊÇÉèÖð²×°¹ý³ÌÖÐÈç¹û³öÏÖ´íÎóµÄ´¦Àí£¬Ò»°ã²»Óù´£¬Ö±½ÓÏÂÒ»²½
µ½Õâ²½³ÌÐòÊÕ¼¯¹»ÁËÐÅÏ¢£¬µã°²×°£¬ÕæÕýµÄ°²×°²Å¿ªÊ¼
³ÌÐòÔÚ¸´ÖÆÎļþ£¬ÅäÖû·¾³£¬µÈ°É
µ½ÕâÀïSQL2005°²×°¾ÍÍê³ÉÁË£¬µãÏÂÒ»²½


Ïà¹ØÎĵµ£º

¾­µäSQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

sql server 2000 2005 ¹²´æÎÊÌâ

Ò»¡¢³õʼ°²×°ÇëÏȰ²×°sqlserver 2000 ÔÙ°²×°sqlserver 2005
¶þ¡¢Èç¹ûÖÐ;sqlserver2000Óöµ½ÎÊÌâÐèÒªÖØ×°£¬Çë°´ÒÔϲ½Öè
1.ÔÚ¿ØÖÆÃæ°å->Ìí¼Óɾ³ý³ÌÐòÖÐɾ³ýsqlserver2000
2.ÔÚ¹ÜÀí¹¤¾ß->·þÎñÖÐÍ£Ö¹sqlserverµÄËùÓзþÎñ
3.ÊÖ¶¯É¾³ýC:\Program Files\Microsoft SQL ServerĿ¼ÏµÄ80Ŀ¼ºÍMSSQLĿ¼£¨±ØÐëÒªÓеڶþ² ......

c# SQLÊý¾Ý¿âÔ¶³ÌÁ¬½Ó¼°ÅäÖ÷½·¨

Ê×ÏÈÅäÖÃSQLSERVER2005£º
´ò¿ª”Microsoft SQL Server Management Studio“ Ö±½ÓÓÃWindows Óû§Á¬½Ó½øÈ룬ÔÙÔÚ“°²È«ÐÔ”ÖеēµÇ¼Ãû”Äڵēн¨µÇ¼Ãû”£¬Äã¾Í¶ÔÓ¦µÄÌíºÃ“È·¶¨”¾Í¿ÉÒÔÁË¡£  
ÔÙÔÚÄã¶ÔÓ¦µÄ“Êý¾Ý¿â”Àï“°²È«ÐÔ” ......

·ÀÖ¹sql×¢Èë ÊÊÓÃÓÚ URL ID ´¿Êý×Ö

Àý×Ó£º  int id = Convert.ToInt32(replace((Request.QueryString["id"]), ""));
    public static string replace(string str, string str2)
    {
        str = str.Replace(";", str2);
        str = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ