¶Á¡¶SQL Server 2005¸ß¼¶¹ÜÀí¡·µÄһЩժҪ... Á¬ÔØ3
¼Ü¹¹
¼Ü¹¹ÈÃÓû§Äܹ»½«Êý¾Ý¿â¶ÔÏó¸ù¾ÝÆäÓÃ;½øÐзÖ×飬¿É½«¼Ü¹¹ÊÓΪÊý¾Ý¿âÖжÔÏóµÄÂß¼·Ö×é¡£µ÷Óüܹ¹ÖеĶÔÏóʱ£¬ÐèҪʹÓÃÖÁÉÙ°üº¬Á©²¿·ÖµÄÃû³Æ¡£Óû§±È½ÏÊìϤdbo¼Ü¹¹£¬¶ÔÓÚ¸ø¶¨Êý¾Ý¿â£¬ËüÊÇĬÈϵļܹ¹¡£×îºóµÄ·½·¨ÊÇʹÓÃÁ©²¿·ÖÃû³ÆÀ´ÒýÓÃÊý¾Ý¿â¶ÔÏó¡£
ͬÒå´Ê
ͬÒå´ÊÔÚÊý¾Ý¿â¶ÔÏóºÍ¿Í»§¶ËÖ®¼ä´´½¨Ò»¸ö³éÏó²ã£¬ÊµÖÊÉÏËüΪÊý¾Ý¿â¶ÔÏó´´½¨ÁíÒ»¸öÂß¼Ãû³Æ¡£ÕâÖÖ³éÏóʹµÃÁ¬½Ó·þÎñÆ÷ʱ·Ç³£·½±ã¡£¶ÔÓÚÁ´½Ó·þÎñÆ÷£¬ÐèҪʹÓÃÓÉ4²¿·Ö×é³ÉµÄÏÞ¶¨·û£¬ÀàËÆÈçÏ´úÂë¡£
Select column1,column2
from LinkedServerName.DatabaseName.SchemaName.TableName
Õâ¸ö³¤Ãû³Æ¸ø¿ª·¢ÈËÔ±´øÀ´ÁËÒ×ÓÃÐÔÎÊÌ⣬ËûÃÇÿÌìÔÚÊäÈë´óÁ¿ÕâÖÖ³¤¶ÈµÄ¶ÔÏóÃû³Æºó¿ÉÄÜ»áʹÊÖ³é½î¡£Í¨¹ýͬÒå´Ê£¬¿É´´½¨Öض¨Ïò·û£¬Ê¹µÃÈκÎʱºòÓÐÈËÊäÈëSchemaName.SynonymNameʱ½«×Ô¶¯Ó³Éäµ½LinkedServerName.DatabaseName.SchemaName.TableName¡£
×÷Ϊ³éÏó²ã£¬Í¬Òå´ÊÔÚÒª½«²éѯӳÉ䵽бí»ò·þÎñÆ÷ʱҲ·Ç³£ÓÐÓá£
×¢Ò⣺ͬÒå´Ê²»ÄÜÒýÓÃÁíÒ»¸öͬÒå´Ê¡£
¶¯Ì¬¹ÜÀíÊÓͼ
¶¯Ì¬¹ÜÀíÊÓͼ£¨DMV£©ºÍº¯Êý·µ»ØÓйØSQL ServerʵÀýºÍ²Ù×÷ϵͳµÄÐÅÏ¢¡£DMV¿ÉÌṩ¸÷ÖÖÀàÐ͵ÄÐÅÏ¢£¬°üÀ¨ÓйØI/O×ÓϵͳºÍRAMµÄÊý¾ÝÒÔ¼°ÓйØService BrokerµÄÐÅÏ¢¡£
ÎÞÂÛºÎʱÆô¶¯ÊµÀý£¬SQL Server¶¼½«¿ªÊ¼±£´æ·þÎñÆ÷״̬ºÍÕï¶ÏÐÅÏ¢µ½DMVÖС£µ±Í£Ö¹²¢Æô¶¯¸ÃʵÀýʱ£¬ÔÚÊÓͼÖн«Çå¿ÕÕâЩÐÅÏ¢£¬²¢ÔØÈëÐÂÊý¾Ý¡£¿ÉÒÔÏñSQL ServerÖеÄÈκÎÆäËû±íÒ»Ñù£¬Ê¹ÓÃÁ©²¿·ÖÏÞÖÆÃû³ÆÀ´²éѯÊÓͼ¡£Êµ¼ÊÉÏ£¬DMVÓÐʱºòÒ²Óк¯Êý£¬Ò²¿ÉÒÔ½ÓÊܲÎÊý¡£
Ïà¹ØÎĵµ£º
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
--ÓÃJOB.
--SQL SERVER2000ΪÀý
ÆóÒµ¹ÜÀíÆ÷—>Êý¾Ý¿â·þÎñÆ÷—>¹ÜÀíĿ¼—>SQL SERVER´úÀí—>×÷Òµ—>ÓÒ¼ü Ñ¡—>н¨
³£¹æÑ¡ÏîÒ³—>ÊäÈë×÷ÒµÃû³Æ—>Ñ¡ÖÐËùÓÐÕß¡£
²½ÖèÑ¡ÏîÒ³—>н¨—>ÊäÈë²½ÖèÃû—>Àà ......
OracleϵÁУºSQL
Ò»£¬Ê²Ã´ÊÇSQL£¿
1£¬SQLÈ«³ÆÊÇ“½á¹¹»¯²éѯÓïÑÔ(Structured Query Language)”£¬¹ØϵÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»ÖÖ²éѯÓïÑÔ¡£
2£¬SQLÊǸ߼¶µÄ·Ç¹ý³Ì»¯±à³ÌÓïÑÔ£¬¾ßÓÐÍêÈ«²»Í¬µ×²ã½á¹¹µÄ²»Í¬Êý¾Ý¿âϵͳ¿ÉÒÔʹÓÃÏàͬµÄSQLÓïÑÔ×÷ΪÊý¾ÝÊäÈëÓë¹ÜÀíµÄ½Ó¿Ú¡£
3£¬ÒԼǼ¼¯ºÏ×÷Ϊ²Ù× ......
/*
lvl1 lvl2 lvl3 lvl4 lvl
4 3 4 1
3 2 2&nb ......