Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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\£¨


Ïà¹ØÎĵµ£º

SQL2005ºÍ(Excel |access)Ö®¼äµÄÊý¾Ýµ¼Èëµ¼³ö


Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º    
  
  
--Excel---->SQL2005  µ¼È룺    
  
  
select * into useinfo from O ......

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

SQL*PLUS³£ÓÃÃüÁîʹÓôóÈ«

OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£ 
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È» ......

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

¾ÛºÏº¯Êý (Entity SQL)

SQL Server .NET Framework Êý¾ÝÌṩ³ÌÐò (SqlClient) Ìṩ¾ÛºÏº¯Êý¡£¾ÛºÏº¯Êý¶ÔÒ»×éÊäÈëÖµÖ´ÐмÆËã²¢·µ»ØÒ»¸öÖµ¡£ÕâЩº¯ÊýλÓÚ SqlServer ÃüÃû¿Õ¼äÖУ¬¸ÃÃüÃû¿Õ¼äÔÚÄúʹÓà SqlClient ʱ¿ÉÓá£Ìṩ³ÌÐòµÄÃüÃû¿Õ¼äÊôÐÔʹʵÌå¿ò¼Ü¿ÉÒÔÈ·¶¨´ËÌṩ³ÌÐò¶ÔÌØ¶¨¹¹Ô죨ÈçÀàÐͺͺ¯Êý£©Ê¹ÓÃÄĸöǰ׺¡£
ϱíÏÔʾ SqlClient ¾ÛºÏº¯Êý¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ