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

SQL Server 2005 µÄĬÈÏʵÀýºÍÃüÃûʵÀýµÄÎļþλÖÃ

SQL Server 2005 Áª»ú´ÔÊ飨2008 Äê 11 Ô£©
SQL Server 2005 µÄĬÈÏʵÀýºÍÃüÃûʵÀýµÄÎļþλÖÃ
¸üÐÂÈÕÆÚ£º 2005 Äê 12 Ô 5 ÈÕ
Microsoft SQL Server 2005 µÄ°²×°°üº¬Ò»¸ö»ò¶à¸öµ¥¶ÀµÄʵÀý¡£ÎÞÂÛÊÇĬÈϵĻ¹ÊÇÃüÃûµÄʵÀý£¬¶¼ÓÐ×Ô¼ºµÄÒ»Ì׳ÌÐòÎļþºÍÊý¾ÝÎļþ£¬ÒÔ¼°Ò»Ì×ÔÚ¼ÆËã»úÉϵÄËùÓÐʵÀýÖ®¼ä¹²ÏíµÄ¹«¹²Îļþ¡£
¶ÔÓÚ°üº¬Êý¾Ý¿âÒýÇæ¡¢Analysis Services ºÍ Reporting Services µÄ SQL Server ʵÀý£¬Ã¿¸ö×é¼þ¶¼ÓÐÒ»Ì×ÍêÕûµÄÊý¾ÝÎļþºÍ¿ÉÖ´ÐÐÎļþ£¬ÒÔ¼°ÓÉËùÓÐ×é¼þ¹²ÏíµÄ¹«¹²Îļþ¡£
ΪÁ˸ôÀëÿ¸ö×é¼þµÄ°²×°Î»Öã¬ÔÚ¸ø¶¨µÄ SQL Server ʵÀýÖÐΪÿ¸ö×é¼þ¶¼Éú³ÉÁËΨһµÄʵÀý ID¡£Õâʹµ¥¸ö×é¼þ¿ÉÒÔÉý¼¶µ½½«À´µÄ SQL Server °æ±¾£¬¶øÓëÆäËû SQL Server ×é¼þÎ޹ء£
ÖØÒªÌáʾ£º
Ç벻Ҫɾ³ýÏÂÁÐÈκÎĿ¼»òÆäÖеÄÄÚÈÝ£ºBinn¡¢Data¡¢Ftdata¡¢HTML »ò 1033¡£ÈçÓбØÒª£¬¿ÉÒÔɾ³ýÆäËûĿ¼£»µ«ÊÇ£¬Èç¹û²»Ð¶Ôز¢ÖØа²×° SQL Server 2005£¬Ôò¿ÉÄÜÎÞ·¨¼ìË÷ʧȥµÄ¹¦ÄÜ»òÊý¾Ý¡£
×¢Ò⣺
²»ÒªÉ¾³ý»òÐÞ¸Ä HTML Ŀ¼ÖеÄÈκΠ.htm Îļþ¡£ËüÃǶÔÓÚ SQL Server ¹¤¾ßµÄÕý³£ÔËÐÐÊDZØÐèµÄ¡£
 ËùÓÐ SQL Server 2005 ʵÀýµÄ¹²ÏíÎļþ
µ¥Ì¨¼ÆËã»úÉϵÄËùÓÐʵÀýʹÓõĹ«¹²Îļþ°²×°ÔÚÎļþ¼Ð systemdrive:\Program Files\Microsoft SQL Server\90 ÖУ¬ÆäÖÐ systemdrive ÊÇ°²×°×é¼þµÄÇý¶¯Æ÷ºÅ¡£Í¨³£ÎªÇý¶¯Æ÷ C¡£
×¢Ò⣺
³ÌÐòÎļþºÍÊý¾ÝÎļþ²»ÄÜ°²×°ÔÚ¿ÉÒƶ¯´ÅÅÌÇý¶¯Æ÷ÉÏ£¬²»ÄÜ°²×°ÔÚʹÓÃѹËõµÄÎļþϵͳÉÏ£¬Ò²²»ÄÜ°²×°ÔÚ¹ÊÕÏתÒÆȺ¼¯ÊµÀýµÄ¹²ÏíÇý¶¯Æ÷ÉÏ¡£
 ÎļþλÖúÍ×¢²á±íÓ³Éä
SQL Server °²×°¹ý³ÌÖУ¬ÎªÃ¿¸ö·þÎñÆ÷×é¼þÉú³ÉÒ»¸öʵÀý ID¡£´Ë SQL Server °æ±¾ÖеķþÎñÆ÷×é¼þÊÇÊý¾Ý¿âÒýÇæ¡¢Analysis Services ºÍ Reporting Services¡£ÊµÀý ID µÄ¸ñʽΪ MSSQL.n£¬ÆäÖÐ n ÊÇ°²×°×é¼þµÄÐòºÅ¡£ÊµÀý ID ÓÃÔÚÎļþĿ¼ºÍ×¢²á±í¸ùĿ¼ÖС£
µÚÒ»¸öÉú³ÉµÄʵÀý ID Ϊ MSSQL.1£¬ÆäËûʵÀýµÄ ID ºÅÒÀ´ÎµÝÔö£¬Èç MSSQL.2£¬MSSQL.3 µÈ¡£Èç¹ûÓÉÓÚжÔضøʹ ID ÐòÁÐÖжϣ¬Ôò½«Éú³É ID ºÅÀ´Ìî³äÖжϡ£×îа²×°µÄʵÀý¿ÉÄܲ¢²»×ÜÊÇÓÐ×î¸ßµÄʵÀý ID ºÅ¡£
·þÎñÆ÷×é¼þÒÔ <instanceID>\<component name> ¸ñʽ°²×°ÔÚĿ¼ÖС£ÀýÈ磬°üº¬Êý¾Ý¿âÒýÇæ¡¢Analysis Services ºÍ Reporting Services µÄĬÈÏʵÀý»òÃüÃûʵÀý¾ßÓÐÒÔÏÂĬÈÏĿ¼£º
<Program Files>\Microsoft SQL Server\MSSQL.1\MSSQL\£¨¶ÔÓÚÊý¾Ý¿âÒýÇ棩
<Program Files>\Microsoft SQL Server\MSSQL.2\OLAP\£¨


Ïà¹ØÎĵµ£º

½«accessµ¼ÈëSQL server

Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ  czdImport Dat ......

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......

ABAP ͨ¹ýSQLÐÞ¸Äij¸ö³ÌÐòµÄËø¶¨×´Ì¬

ÏȰѳÌÐò´ò¿ª,²Ëµ¥ÉÏ Environment/Examples/Performance Examples ÔÚ¿Õ°×´¦ÊäÈë
ÒªÖ´ÐеijÌÐò,×¢ÒâÒ»¶¨ÒªÕýÈ·,·ñÔòºó¹ûºÜÑÏÖØ,ºÇºÇ.
data: itab type table of TRDIR with header line.
select  *  from TRDIR into table itab
where NAME = 'ZHRRPT1011'.
read table itab with key name = 'ZHRRPT1011'.
......

SQL Server 2000 Êý¾Ýͬ²½¹ý³Ì

SQL Server
2000¶©ÔÄÓë·¢²¼µÄ¾ßÌå²Ù×÷
ͬ²½¹ý³Ì
¡¡¡¡Ò»¡¢×¼±¸¹¤×÷£¬Èç¹ûÍê³ÉÔò¿ÉÌø¹ý¡£
¡¡¡¡1¡¢ÄÚÍøDB·þÎñÆ÷×÷Ϊ·¢²¼·þÎñÆ÷£¬ÍâÍøDB·þÎñÆ÷×÷Ϊ¶©ÔÄ·þÎñÆ÷¡£
¡¡¡¡·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷ÉϷֱ𴴽¨WindowsÓû§jl,ÃÜÂëjl£¬Á¥ÊôÓÚadministrators£¬×¢ÒâÒª±£³ÖÒ»Ö¡£
¡¡¡¡2¡¢·¢²¼·þÎñÆ÷ÉÏ´´½¨Ò»¸ö¹²ÏíĿ¼£¬×÷Ϊ·¢²¼¿ìÕÕÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ