ʹÓÃ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ÅÄÜÉú³Éͼ¡£
½á¹û´óÖÂÏòÏÂÃæÕâÑù¡£
Ïà¹ØÎĵµ£º
1.¼¤»îSQL¸ú×Ù
´Óoracle10gÒÔºóÌṩÁËеķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
֮ǰ¾É·½·¨ÊÇʹÓà alter session set events .. »òÕßʹÓÃdbms_system.set_ev·½Ê½
ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
fr ......
ͨ³£Çé¿öÏ£¬SQL ServerÀïÃæµÄÉú³ÉSQL½Å±¾£¬Ö»»á°üº¬Êý¾Ý¿â¼°±íµÄ×ֶνṹ£¬¶ø²»»á°üº¬±íµÄÊý¾Ý£¬Ò²¾ÍÊÇSQL½Å±¾ÀïÃæÖ»ÓÐCreate database£¬Create table ÕâÑùµÄÓï¾ä£¬Ã»ÓÐinsert into¡£
ÒòΪSQL Server²¢²»°üº¬Õâ¸ö¹¦ÄÜ£¬Ö»ÄÜ¿¿µÚÈý·½µÄ´úÂëÁË¡£
ÒÔÏ´洢¹ý³Ì¿ÉÒÔʵÏÖ£º
CREATE PROCEDURE dbo.UspOutputData
@tablenam ......
TITLE: SQL Server °²×°³ÌÐòʧ°Ü¡£
------------------------------
SQL Server °²×°³ÌÐòÓöµ½ÒÔÏ´íÎó:
MsiGetProductInfo ÎÞ·¨¼ìË÷ Product Code Ϊ“{95120000-00B9-0409-0000-0000000FF1CE}”µÄ°üµÄ ProductVersion¡£´íÎó´úÂë: 1605¡£¡£
Óöµ½Õâ¸ö´íÎóʱ£¬½â¾ö·½·¨ÈçÏ£º
µ±ÏµÍ³ÌáʾÈç {95120000-0 ......
¶ÔInºÍexistsµÄÐÔÄܽøÐбȽϣ¬Ê×ÏÈÒªÖªµÀËüÃÇÁ½ÕßµÄÇø±ð¡£
in: È·¶¨¸ø¶¨µÄÖµÊÇ·ñÓë×Ó²éѯÖеÄÖµ»òÁбíÖеÄÖµÏàÆ¥Åä¡£
exists: Ö¸¶¨Ò»¸ö×Ó²éѯ£¬¼ì²âÐÐÊÇ·ñ´æÔÚ¡£
¿É·ÖÎöËüÃǵIJéѯÓï¾äÀ´µÃ³öÕæʵµÄ²î±ð:
in
±ÈÈçSelect * from t1 where x in ( select y from t2 )
Ö´ÐеĹý³ÌÏ൱ÓÚ:
select *
from t1, ( ......