Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ͼÎÄÏê½âÈçºÎÓÃPowerDesignerÉè¼ÆSQL Server

¹¤¾ß£º
Sybase PowerDesigner 12.5
Microsoft SQL Server 2005
µÚÒ»²½£º¸ÅÒªÉè¼Æ
´ò¿ªPowerDesignerÈí¼þ£¬Éè¼Æ“¸ÅÄîÊý¾ÝÄ£ÐÍ”(Conceptual Data Model)£º
 
ͼ1
Éè¼Æ±í½á¹¹£º
 
ͼ2
ÔÚÉè¼ÆÊôÐÔ(×Ö¶Î)µÄʱºò£¬Èý¸ö×Öĸ(M¡¢P¡¢D)·Ö±ð±íʾ£º
M£ºÊÇ·ñΪ¿Õ;(√±íʾ²»ÔÊÐíΪ¿Õ)
P£ºÊÇ·ñΪÖ÷¼ü;
D£ºÊÇ·ñÔÚ¸ÃÈí¼þµÄÊÓͼÖÐÏÔʾ;
µÚ¶þ²½£ºÏêϸÉè¼Æ
½«“¸ÅÄîÊý¾ÝÄ£ÐÍ”Éè¼ÆµÄ±íת»»Îª“ÎïÀíÊý¾ÝÄ£ÐÍ”(Physical Data Model)£¬Êµ¼ÊÉÏÊÇ´Ó“¸ÅÒªÉè¼Æ”ת»»Îª“ÏêϸÉè¼Æ”£¬¼´¶Ô±íµÄ¾ßÌåʵÏÖ¡£
Ñ¡Ôñ“Tools”-->“Generate Physical Data Model…”¼´¿É¡£
 
ͼ3
È»ºóÑ¡Ôñ SQL Server 2005Êý¾Ý¿â¹ÜÀíÈí¼þ£º
 
ͼ4
µã»÷“È·¶¨”°´Å¥ÒԺ󣬾ͲúÉúÁ˶ÔÓ¦“SQL Server 2005”Êý¾Ý¿âµÄ±í¡¢ÊôÐÔ¡¢¹ØϵµÄ¾ßÌåʵÏÖ¡£
µÚÈý²½£ºÔÚSQL Server 2005ÖÐÊÖ¶¯´´½¨Êý¾Ý¿â
±ÈÈ磺ÎÒÔÚSQL Server 2005ÖÐÊÖ¶¯´´½¨Êý¾Ý¿â“Students”ʾÀý¡£
µÚËIJ½£ºÔÚÊý¾ÝÔ´ODBCÖÐÅäÖÃÓû§Êý¾ÝÔ´
±ÈÈ磺ÎÒÔÚÓû§Êý¾ÝÔ´ÖУ¬Ìí¼ÓÊý¾Ý¿â“Students”µÄÊý¾ÝÔ´¡£
 
ͼ5
µÚÎå²½£ºÔÚSQL Server 2005ÖÐ×Ô¶¯´´½¨±í½á¹¹
Ê×ÏÈ£º¸ù¾Ý“ÎïÀíÊý¾ÝÄ£ÐÍ”(Physical Data Model)×Ô¶¯½¨Á¢ÏàÓ¦µÄSQLÓï¾ä£º
 
ͼ6
Æä´Î£ºÖ´ÐÐÆä´´½¨µÄSQLÓï¾äÎļþ£¬½«Êý¾Ý±í½á¹¹×Ô¶¯´´½¨µ½SQL Server 2005Êý¾Ý¿âÖУº
 
ͼ7
Íê³ÉÒÔÉϲ½Öèºó£¬Ë¢ÐÂSQL Server 2005Êý¾Ý£¬½«»á¿´µ½ÄãËù´´½¨µÄÏà¹Ø±í½á¹¹¡£
µ±È»£¬ÒÔÉÏÁ½¸ö²½Öè(¼´£ºÍ¼6ºÍͼ7)¿ÉÒÔÒ»²½Íê³É£º
Ö»ÒªÔÚ“Database”à“Database Generation”ÖУ¬Ñ¡Ôñ“Direct generation”¼´¿É£º
 
ͼ8
ÕâÑù£¬Õû¸öʹÓÃPowerDesignerÉè¼ÆSQL ServerÊý¾Ý¿âµÄ²½Ö裬¾ÍÈ«²¿Íê³É!


Ïà¹ØÎĵµ£º

ÈçºÎÓ¦¶ÔWinformsÖÐSQLµÄ×¢Èëʽ¹¥»÷

SqlÓï¾ä×÷Ϊ¹ú¼Ê±ê×¼µÄÊý¾Ý¿â²éѯÓï¾ä£¬±±¾©°á¼Ò¹«Ë¾ ±±¾©Êèͨ¹«Ë¾ÔÚ¸÷ÖÖ±à³Ì»·¾³Öеõ½Á˹㷺µÄÓ¦Óá£×÷Ϊһ¸ö³ÉÊì¡¢Îȶ¨µÄϵͳ£¬Óû§µÇ½ºÍÃÜÂëÑéÖ¤ÊDZز»¿ÉÉٵġ£ÔÚƽʱµÄ±à³Ì¹¤×÷ÖÐÐí¶à³ÌÐòÔ±ÔÚÓÃsqlÓï¾ä½øÐÐÓû§ÃÜÂëÑé֤ʱÊÇͨ¹ýÒ»¸öÀàËÆÕâÑùµÄÓï¾äÀ´ÊµÏֵģº
 strSel = " Select * from Óû§±í where ÐÕÃû= '" ......

SQL Server 2005ÍêȫжÔØ

SQL Server 2005µÄжÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾­³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßжÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏжÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öÊ°빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØжÔع¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.mic ......

SQL Server 2005/2008¹ÜÀí£¨´ýÐø£©

-- ²é¿´µ±Ç°dbµÄµÇ½
select * from sys.sql_logins
-- ²é¿´ÐÔÄܼÇÊýÆ÷
SELECT * from sys.dm_os_performance_counters
-- Ö´ÐйýµÄÏß³ÌËùÓöµ½µÄËùÓеȴý(²»Êǵ±Ç°ÕýÔÚÔËÐеÄÏß³Ì, Ϊ×ÔÉÏ´ÎÖØÖÃͳ¼ÆÐÅÏ¢»òÆô¶¯·þÎñÆ÷ÒÔÀ´ÀÛ»ýµÄÊý¾Ý),¿É·ÖÎö¿¿Ç°µÄ¼¸¸öµÈ´ý½Ï¸ßµÄʼþ¡£
select * from sys.dm_os_wait_stats order by wa ......

Excelµ¼ÈëSQL£¨2£©

      ÓõÚÒ»ÖÖ·½·¨£¬ÉÏ´«·þÎñÆ÷ºó£¬ÔÚһЩ·þÎñÆ÷ÖУ¬¿ÉÄÜ»á³öÏÖÒÔÏ´íÎó£º
    ±ØÐëÔÚweb.configÖÐ¼Ó <system.web><identity impersonate="false"/></system.web> ,·ñÔò³öÏÖ´íÎó£ºSystem.Data.OleDb.OleDbException: δָ¶¨µÄ´íÎó¡£¼ÓÁËÒԺ󣬵ã¶à¼¸´ÎÁ´½Ó£¬» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ