Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿âµÄ²½Ö裬¾ÍÈ«²¿Íê³É!


Ïà¹ØÎĵµ£º

pl/sql developerµÄʹÓÃ

Ôړн¨”²Ëµ¥ÖУ¬ÓÐProgram window£¬Test window£¬SQL windowºÍCommand windowµÈ¡£
SQL windowºÍCommand windowÓÐʲôÇø±ð£¿£¿
Command windowʵÏÖÁËSQL*PlusµÄËùÓй¦ÄÜ£¬ÔÊÐíÔËÐÐsql*plusÃüÁsqlÃüÁsql½Å±¾¡£
SQL windowÓÃÓÚÖ´ÐÐsqlÓï¾ä£¬ÏÔʾsqlÊä³ö£¬Ö´ÐÐͳ¼ÆÐÅÏ¢¡££¨²âÊÔsqlÓï¾ä£¬²é¿´±íÖеÄÊý¾Ý£¬ ......

SQL Server 2005ÍêȫжÔØ

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

50ÖÖ·½·¨ÇÉÃîÓÅ»¯ÄãµÄSQL ServerÊý¾Ý¿â

Ô­ÎÄÁ´½Ó:http://blog.btidea.com/article.asp?id=440
²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ£º
¡¡¡¡
¡¡¡¡1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
¡¡¡¡
¡¡¡¡2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
¡¡¡¡
¡¡¡¡3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
¡¡¡¡
¡¡¡¡4¡¢ÄÚ´æ²»×ã
¡¡¡¡
¡¡¡¡5¡¢ÍøÂç ......

jspÓëSQL Server 2000 µÄÁ¬½Ó

ÖÕÓڸ㶨JSPÁ¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌâÁË
2008Äê01ÔÂ29ÈÕ ÐÇÆÚ¶þ 15:54
    Ç°¼¸Ì죬ƽƽͬѧһֱÔÚ¸ãJSP Á¬½ÓSQL Server 2000Êý¾Ý¿âµÄÎÊÌ⣬һֱÁ¬²»ÉÏ£¬È»ºó½ÐÎÒÈ¥°ïËû¿´¿´£¬Æ¾×ÅÒÔÇ°µÄ¾­Ñ飬¸ãÁËÒ»¸öÏÂÎ磬ºÙºÙ£¡ÖÕÓÚ°ïËûÁ¬½ÓÉÏÁË£¬Ö÷Òª²½ÖèÈçÏ£º
    1¡¢ÐèÒªµÄ¶«Î÷´ó¼Ò¿ÉÒÔµ½Î ......

¾«µäSQLÓï¾ä

·ÖÀàͳ¼Æ×ÜÊý²¢ÅÅÐò¶à±íÁªºÏ²éѯµÄÁ½ÖÖ·½·¨
Àý:
²éѯµØÇø±íÖи÷Ê¡ÏÂÃæ³ÇÊÐ×ÜÊý,²¢¶Ô²éѯ½á¹ûÈ¡Ç°Ê®Ãû
·¨Ò»:
select b.id,a.[name],b.counts from n_area a,(select top 10 parent_id as id,sum(parent_id) as counts from n_area where parent_id<>0 group by parent_id order by sum(parent_id) desc
) b where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ