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 SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
ÏȰѳÌÐò´ò¿ª,²Ëµ¥ÉÏ 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'.
......
OracleµÄsql*plusÊÇÓëoracle½øÐн»»¥µÄ¿Í»§¶Ë¹¤¾ß¡£ÔÚsql*plusÖУ¬¿ÉÒÔÔËÐÐsql*plusÃüÁîÓësql*plusÓï¾ä¡£
ÎÒÃÇͨ³£Ëù˵µÄDML¡¢DDL¡¢DCLÓï¾ä¶¼ÊÇsql*plusÓï¾ä£¬ËüÃÇÖ´ÐÐÍêºó£¬¶¼¿ÉÒÔ±£´æÔÚÒ»¸ö±»³ÆÎªsql bufferµÄÄÚ´æÇøÓòÖУ¬²¢ÇÒÖ»Äܱ£´æÒ»Ìõ×î½üÖ´ÐеÄsqlÓï¾ä£¬ÎÒÃÇ¿ÉÒÔ¶Ô±£´æÔÚsql bufferÖеÄsql Óï¾ä½øÐÐÐ޸ģ¬È» ......
½ñÌìÓÖ¿´µ½ÐÂ¼ÓÆÂµÄͬÊ·¢¹ýÀ´µÄÒ»¶ÎSQLÓï¾ä£¬»¹ÊÇÀÏÎÊÌ⣬ʱ¼ä¶Ô±ÈÖ±½ÓÓôóÓÚСÓںš£Ì¾ÁËÉùÆøºó£¬ÊÖ¶¯¸ø¸Ä³ÉdatediffÁË£¬¿ÉÊÇÒ»ÔËÐгö´í£¬´íÎóÌáʾÈçÏ£º
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting datetime from character string.
ΪÁË˵Ã÷·½±ã£¬ÕâÀï¾Í¼ò»¯Ò»¸öÀý×ÓºÃÁË¡£
create tab ......