SQL Server 2005µ¼Èëµ¼³ö´æ´¢¹ý³Ì
1. ¿ÉÒÔÓýű¾±¸·Ý
¡¡¡¡manger studio--ÓÒ¼üÄãµÄÊý¾Ý¿â--ÈÎÎñ--Éú³É½Å±¾
¡¡¡¡Ôڽű¾Éú³ÉÏòµ¼µÄ"Ñ¡Ôñ¶ÔÏóÀàÐÍ"²½ÖèÖÐ, ½«"´æ´¢¹ý³Ì"Ñ¡ÉÏ, ÔÚ½ÓÏÂÀ´µÄ"Ñ¡Ôñ´æ´¢¹ý³Ì"µÄ²½ÖèÖÐ, Ñ¡ÔñËùÓеĴ洢¹ý³Ì(»òÕßÄãÒª¸´ÖƵĴ洢¹ý³Ì)
¡¡¡¡Íê³Éºó, ËùÓд洢¹ý³ÌµÄ½Å±¾»áÉú³ÉÔÚÒ»¸öеIJéѯ´°¿ÚÖÐ, ¹ØµôÉú³É½Å±¾Ïòµ¼, ÔÚÉú³ÉµÄ´æ´¢¹ý³Ì½Å±¾µÄ´°¿ÚÖÐ, ÓÒ¼ü--Á¬½Ó--¸ü¸ÄÁ¬½Ó, Á¬½Óµ½´æ´¢¹ý³Ì¸´ÖƵÄÄ¿µÄ·þÎñÆ÷, Ñ¡ÔñºÏÊʵÄÊý¾Ý¿â, °´F5Ö´Ðм´¿ÉÍê³É´æ´¢¹ý³ÌµÄ¸´ÖÆ.
¡¡¡¡2. ¿ÉÒÔʹÓÃSSIS, ´´½¨SSIS°ü, ¾Í¿ÉÒÔʹÓÃÊý¾Ý¿â¶ÔÏó¸´ÖƵÄÕâ¸ö×é¼þÀ´¸´ÖÆ´æ´¢¹ý³Ì(SSISÏ൱ÓÚ2000µÄDTS)
ʵ¼ÊÔÚ×öµÄʱºò£¬ÏȽøÐнű¾µÄ±¸·Ý£¬ÕâÀï¿ÉÒÔ±¸·Ý³ÉsqlÎļþ£¬È»ºóÑ¡ÔñÒ»¸öÊý¾Ý¿â£¬ÔÚÕâ¸öÊý¾Ý¿âÑ¡ÔñÓÒ¼ü£¬Ð½¨Ò»¸ö²éѯ£¬°ÑÕâ¸ösqlÎļþµÄÄÚÈÝÈ«²¿¸´ÖƹýÈ¥£¬È»ºóµã»÷Ö´ÐУ¬¾Í¿ÉÒÔÍê³É´æ´¢¹ý³ÌµÄÒÆÖ²¡£
Ïà¹ØÎĵµ£º
SQL code
´´½¨½ÇÉ«£¬Óû§£¬È¨ÏÞ
/*--ʾÀý˵Ã÷
ʾÀýÔÚÊý¾Ý¿âpubsÖд´½¨Ò»¸öÓµÓбíjobsµÄËùÓÐȨÏÞ¡¢ÓµÓбítitlesµÄSELECTȨÏ޵ĽÇÉ«r_test
Ëæºó´´½¨ÁËÒ»¸öµÇ¼l_test£¬È»ºóÔÚÊý¾Ý¿âpubsÖÐΪµÇ¼l_test´´½¨ÁËÓû§ÕË»§u_test
ͬʱ½«Óû§ÕË»§u_testÌí¼Óµ½½ÇÉ«r_testÖУ¬Ê¹Æäͨ¹ýȨÏ޼̳лñÈ¡ÁËÓë½ÇÉ«r_t ......
#ÐÂÔöÒ»¸ö×ֶΣ¬Ä¬ÈÏֵΪ0£¬·Ç¿Õ£¬×Ô¶¯Ôö³¤£¬Ö÷¼ü
alter table tabelname add new_field_name field_type default 0 not null auto_increment ,add primary key (new_field_name);
#Ôö¼ÓÒ»¸öÐÂ×Ö¶Î
alter table tableName add new_field_name field_type;
alter table tableNam ......
×òÍí£¬µ½Î¢Èí¹Ù·½ÏÂÁËÒ»¸ö32°æ±¾µÄTrial°æ±¾¡£ÎļþÃûΪSQLFULL_x86_ENU.exe¡£Îļþ´óСΪ1.30G×óÓÒ¡£ÒòΪֻÓÐ32λһ¸ö°æ
±¾£¬±ÈSQL Server 2008ÄǸö3GµÄҪС¶àÁË¡£ºÇºÇ¡£
http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx
ÏÂ
ÔØÍê³Éºó£¬ÏÈжÔØÔÀ´µÄSQL Server 2008¡¡sp2,½á¹ûÕûÕûÔËÐÐÁËÁ½¸ ......
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......
<!--MySql Çý¶¯³ÌÐò eg. mysql-connector-java-5.0.4-bin.jar-->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- JDBC URL -->
......