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\£¨
Ïà¹ØÎĵµ£º
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
father±í son±í
fid fname sid sname fid height money
1 a 100 s1 1 1.7 7000
2 b 101 s2 2 1.6 8000
3 c 102&nbs ......
/*
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 ......
ÒÔÏÂʵÏÖ¸´ÖƲ½Ö裨ÒÔ¿ìÕÕ¸´ÖÆÎªÀý£©
ÔËÐÐÆ½Ì¨SQL SERVER 2005
Ò»¡¢×¼±¸¹¤×÷£º
1£®½¨Á¢Ò»¸ö WINDOWS Óû§£¬ÉèÖÃΪ¹ÜÀíԱȨÏÞ£¬²¢ÉèÖÃÃÜÂ룬×÷Ϊ·¢²¼¿ìÕÕÎļþµÄÓÐЧ·ÃÎÊÓû§¡£
2£®ÔÚSQL SERVERÏÂʵÏÖ·¢²¼·þÎñÆ÷ºÍ¶©ÔÄ·þÎñÆ÷µÄͨÐÅÕý³££¨¼´¿ÉÒÔ»¥·Ã£©¡£´ò¿ª1433¶Ë¿Ú£¬ÔÚ·À»ðǽÖÐÉèÌØÀý
3£®ÔÚ·¢²¼·þÎñÆ÷ÉϽ¨Á¢Ò»¸ö ......