Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡¢EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

AccessºÍSQL2000ÖÐÓï¾äµÄÇø±ð

1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......

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'.
......

PL/SQL±í


/*
PL/SQL±í---table()º¯ÊýÓ÷¨£º
ÀûÓÃtable()º¯Êý£¬ÎÒÃÇ¿ÉÒÔ½«PL/SQL·µ»ØµÄ½á¹û¼¯´úÌætable¡£
oracleÄÚ´æ±íÔÚ²éѯºÍ±¨±íµÄʱºòÓõıȽ϶࣬ËüµÄËÙ¶ÈÏà¶ÔÎïÀí±íÒª¿ì¼¸Ê®±¶¡£
simple example£º
1¡¢table()½áºÏÊý×飺
*/
create or replace type t_test as object(
id integer,
rq date,
mc varchar2(60)
);
cr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ