ʹÓÃvisio 2003½¨Á¢sql server·´Ïò¹¤³Ì
Èý²½×ß¡£
<1>½¨Á¢Êý¾ÝÔ´
´ò¿ª¿ØÖÆÃæ°å—>¹ÜÀí¹¤¾ß—>Êý¾ÝÔ´ (ODBC)£¬»òÖ±½ÓÔËÐÐodbccp32.cplÃüÁî¡£´ò¿ªODBCÊý¾ÝÔ´¹ÜÀíÆ÷¡£Ìí¼ÓÒ»¸öϵͳÊý¾ÝÔ´¡£Ñ¡ÔñSql Server×÷ΪÊý¾ÝÔ´µÄÇý¶¯³ÌÐò£¬¼üÈëÊý¾ÝÔ´Ãû³Ædemo£¬Ñ¡ÔñºÏÊʵÄsql server·þÎñÆ÷£¬È»ºóһ·ĬÈÏÏÂÈ¥¡££¨ÔÚºóÃæµÄ²½ÖèÖпÉÒÔÑ¡ÔñÐèÒª½øÐз´Ïò¹¤³ÌµÄÊý¾Ý¿â£¬Ä¬ÈÏÊÇmaster£©Êý¾ÝÔ´ÐÅÏ¢Èçͼһʾ¡£
ͼһ
<2>ÔÚvisioÖÐн¨Êý¾Ý¿âÄ£ÐÍͼ
´ò¿ªvisio 2003,Îļþ—>н¨—>Êý¾Ý¿â—>Êý¾Ý¿âÄ£ÐÍͼ¡£½¨Á¢Êý¾Ý¿âÄ£ÐÍͼ֮ºó£¬²Ëµ¥À¸¶à³öÒ»¸ö²Ëµ¥Ïî"Êý¾Ý¿â"¡£
<3>·´Ïò¹¤³Ì
²Ëµ¥ÏîÊý¾Ý¿â—>·´Ïò¹¤³Ì¡£Æô¶¯·´Ïò¹¤³ÌÏòµ¼£¬Ò»²½²½Íê³É·´Ïò¹¤³ÌÉèÖá£
1.½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó¡£Ñ¡ÔñvisioÇý¶¯³ÌÐòµÄÀàÐ;ö¶¨ÁË¿ÉÒÔÁ¬½ÓµÄÊý¾Ý¿âÀàÐͼ°¿ÉÓÃÑ¡Ïî¡£Êý¾ÝÔ´Ö¸¶¨Êý¾Ý¿âλÖü°Á¬½ÓÐÅÏ¢¡£ÕâÀïÎÒÃÇÑ¡ÔñvisioÇý¶¯³ÌÐòΪMicrosoft Sql Server,Êý¾ÝԴΪ¸Õ½¨Á¢µÄdemo¡£Èçͼ¶þʾ¡£
ͼ¶þ
2.Á¬½ÓÊý¾ÝÔ´¡£ÊäÈëÓû§ÃûºÍÃÜÂëÓÃÓÚÁ¬½ÓÊý¾ÝÔ´¡£
3.Ñ¡ÔñÒª½øÐз´Ïò¹¤³ÌµÄ¶ÔÏóÀàÐÍ£¬ÈçͼÈýʾ¡£
ͼÈý
4.Ñ¡ÔñÒª½øÐз´Ïò¹¤³ÌµÄ±íºÍÊÓͼ¡£
5.Ñ¡ÔñÒª½øÐÐôÏò¹¤³ÌµÄ´æ´¢¹ý³Ì¡£
6.ÊÇ·ñÏëÈÃÑ¡ÔñÁË·´Ïò¹¤³ÌµÄÏîÌí¼Óµ½µ±Ç°¹¤³ÌÖС£Ñ¡ÔñÊDzÅÄÜÉú³Éͼ¡£
½á¹û´óÖÂÏòÏÂÃæÕâÑù¡£
Ïà¹ØÎĵµ£º
SQL Server 2000 µÄϵͳÊý¾Ý¿â
SQL Server 2000·þÎñÆ÷°²×°ºó»á½¨Á¢4ϵͳÊý¾Ý¿â¡£·Ö±ðÊÇmaster¡¢model¡¢msdb¡¢tempdb¡£
1¡¢masterÊý¾Ý¿â
masterÊý¾Ý¿âÊÇSQL Server 2000ÖÐ×îÖØÒªµÄÊý¾Ý¿â£¬¼Ç¼ÁËSQL Server 2000µÄ·þÎñÆ÷¼¶ÏµÍ³ÐÅÏ¢£¬°üÀ¨ËùÓÐÕË»§ºÍÃÜÂ룬´ÅÅ̿ռ䡢Îļþ·ÖÅäºÍʹÓá¢ÏµÍ³¼¶µÄÅäÖòÎÊý¡ ......
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='CCBZZP';
2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ ......
ͨ³£Çé¿öÏ£¬SQL ServerÀïÃæµÄÉú³ÉSQL½Å±¾£¬Ö»»á°üº¬Êý¾Ý¿â¼°±íµÄ×ֶνṹ£¬¶ø²»»á°üº¬±íµÄÊý¾Ý£¬Ò²¾ÍÊÇSQL½Å±¾ÀïÃæÖ»ÓÐCreate database£¬Create table ÕâÑùµÄÓï¾ä£¬Ã»ÓÐinsert into¡£
ÒòΪSQL Server²¢²»°üº¬Õâ¸ö¹¦ÄÜ£¬Ö»ÄÜ¿¿µÚÈý·½µÄ´úÂëÁË¡£
ÒÔÏ´洢¹ý³Ì¿ÉÒÔʵÏÖ£º
CREATE PROCEDURE dbo.UspOutputData
@tablenam ......
select name as ¿âÃû from master..sysdatabases where dbid>=7 »ñµÃÊý¾Ý¿âÃû³Æ
select * from sysobjects where xtype='u' or xtype='v' ²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡
select name from sysobjects where type='u' ²éѯһ¸ö¿ ......
¶ÔInºÍexistsµÄÐÔÄܽøÐбȽϣ¬Ê×ÏÈÒªÖªµÀËüÃÇÁ½ÕßµÄÇø±ð¡£
in: È·¶¨¸ø¶¨µÄÖµÊÇ·ñÓë×Ó²éѯÖеÄÖµ»òÁбíÖеÄÖµÏàÆ¥Åä¡£
exists: Ö¸¶¨Ò»¸ö×Ó²éѯ£¬¼ì²âÐÐÊÇ·ñ´æÔÚ¡£
¿É·ÖÎöËüÃǵIJéѯÓï¾äÀ´µÃ³öÕæÊµµÄ²î±ð:
in
±ÈÈçSelect * from t1 where x in ( select y from t2 )
Ö´ÐеĹý³ÌÏ൱ÓÚ:
select *
from t1, ( ......