½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ
1.´ò¿ªSQL server enterprise mananger "ÆóÒµ¹ÜÀíÆ÷"
ÔÚÄãÒªµ¼³öµÄ SQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍΪ“Microsoft Access¡£µã “ÎļþÃû(F)” ºóÃæµÄ°´Å¥Ñ¡ÔñÄ¿±ê.MDBÎļþ¡£
4.Ñ¡Ôñ“´ÓÊý¾Ý¿â¸´ÖƱíºÍÊÓͼ”¡£
5.ÎÒÃÇ×¢ÒâÕâÀïÑ¡±íµÄʱºòÓÒ±ßÓÐÒ»¸ö“ת»»”ÁС£SQLµ¼³öֻת»»Êý¾ÝÀàÐͲ¢²»¿¼ÂÇÆäËû½Å±¾ËùÒÔÎÒÃÇÓöµ½µÄ×Ô¶¯±àºÅÎÊÌâÒ²¾Í³öÔÚÕâÀï¡£ÓÐ×Ô¶¯±àºÅµÄÒ»¶¨ÒªµãÑ¡“ת»»”¡£
6.ÎÒÃǻؿ´µ½Ò»¸ö“ÁÐÓ³ÉäºÍת»»”¶Ô»°¿ò¡£ÓÐ×¢Òâµ½×ÔÔöµÄemployeeid int ×ÔÔöÕâÀï±ä³ÉÁËAccessÀïµÄlongÕâ¿Ï¶¨²»¶Ô£¬long²¢²»ÊÇ×Ô¶¯±àºÅ£¬Ö»ºÃÐ޸Ľ¨±í½Å±¾£¬Í¼Æ¬ÉÏÄǸöºìȦÀïµÄ°´Å¥“±à¼SQL”¡£
¿ªÒ»¸öС´°create talbe
ºìȦÖеĽű¾¾ÍÊÇemployeeid µÄ Access½¨±í½Å±¾£¬ÔÚ "NOT NULL" Ç°Ãæ¼ÓÉÏ "IDENTITY (1, 1)"¡£
7.Á¢¼´Ö´ÐС£
ÏÂͼ±íʾ½¨±í¸´ÖÆÒѳɹ¦
8.ÎÒÃÇ´ò¿ªMDBÎļþ¿´¿´ÊDz»ÊÇÈçÎÒÃÇËùÔ¸£¿
OKÍê³É£¬¹§Ï²Äã²Ù×÷³É¹¦
Ïà¹ØÎĵµ£º
Èí¼þÊÇÃâ·ÑʹÓõģ¬×Ô¼º¹¤×÷ÖÐÒ²Ò»Ö±Óã¬Óкܶ๦ÄÜÏëÔö¼Ó£¬ÓÉÓÚʱ¼äÔÒòûȥÕûÀíÐèÇó¡£×Ô´ÓÈ¥Äê·¢²¼V1.0.0°æºóûÓÐÔÚ·¢²¼ÁË£¬±¾´ÎÖ÷ÒªÊÇÔö¼ÓÁ˽âÃÜOracle10g¼ÓÃܶÔÏñµÄ¹¦ÄÜ£¬ÁíÍâ×öÁËһЩСµÄÓÅ»¯£¬·¢ÉÏÀ´Óë´ó¼Ò·ÖÏíһϣ¬ÒòΪÊÇBeta°æ£¬ËùÒÔÒ²Çë´ó¼ÒÁ½⣬Èç¹ûÔÚʹÓýâÃܹ¦ÄÜʱÓöµ½ÎÊÌâ¿ÉÒÔ·¢E ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXC ......
TRUNCATE TABLE ÔÚ¹¦ÄÜÉÏÓë²»´ø Where ×Ó¾äµÄ Delete
Óï¾äÏàͬ£º¶þÕß¾ùɾ³ý±íÖеÄÈ«²¿ÐС£µ« TRUNCATE TABLE ±È Delete Ëٶȿ죬ÇÒʹÓõÄϵͳºÍÊÂÎñÈÕÖ¾×ÊÔ´ÉÙ¡£
Delete
Óï¾äÿ´Îɾ³ýÒ»ÐУ¬²¢ÔÚÊÂÎñÈÕÖ¾ÖÐΪËùɾ³ýµÄÿÐмǼһÏî¡£TRUNCATE TABLE ͨ¹ýÊÍ·Å´æ´¢±íÊý¾ÝËùÓõÄÊý¾ÝÒ³À´É¾³ýÊý¾Ý£¬²¢ÇÒÖ»ÔÚÊÂÎñÈÕÖ¾ÖмÇÂ¼Ò ......
declare @tablename varchar(20)
select @tablename = 'o_ems'
-------------Éú³É±äÁ¿,ʹÓñí¸ñÐÎʽ(ctrl + D)Êä³ö£¬È¡µÚÒ»¸ö×ֶεÄÖµ----------------------------------
select 'private '+
Case when t.name='varchar' Then 'string'
when t.name='char' Then 'string' &nb ......