PowerDesignerÓëSQL ServerÏàÁ¬
PowerDesignerÓëSQL ServerÏàÁ¬
ÒÔÇ°Ìý˵¹ýPowerDesigner¿ÉÒÔºÍÊý¾Ý¿âÁ¬½Ó£¬¸ù¾ÝÔÚPowerDesigner´´½¨µÄÊý¾ÝÄ£ÐÍ´´½¨±í¡¢´¥·¢Æ÷¡¢´æ´¢¹ý³Ìµ½Êý¾Ý¿âÖС£Ò²¿ÉÒÔ½«ÒÑÓеÄÊý¾Ý¿âµ¼³öµ½PowerDesignerÖÐΪÊý¾ÝÄ£ÐÍ¡£½ñÌì×öÁËһϲâÊÔ£¬·¢ÏÖȷʵºÜ¼òµ¥£¬ÏÖÔÚ²Ù×÷²½ÖèÓë´ó¼Ò·ÖÏí£º
0¡¢×¼±¸¹¤×÷
ÏÈÔÚSQL ServerÖд´½¨Ò»Êý¾Ý¿â£¬ÒÔ¹©²âÊÔÓá£
Create database test
1¡¢ ¸ù¾ÝÔÚPowerDesigner´´½¨µÄÊý¾ÝÄ£ÐÍ´´½¨±í¡¢´¥·¢Æ÷¡¢´æ´¢¹ý³Ìµ½Êý¾Ý¿âÖÐ
1£©´ò¿ªPowerDesigner £¬½¨Á¢Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍ
2)ÔÚµ¯³öµÄ¶Ô»°¿òÖб£³ÖĬÈÏÉèÖÃ
3)½«Ð½¨µÄphysical data model ÖØÃüÃûΪtest
4)ÔÚÆäÖн¨Á½¸ö±í,´´½¨Á½¸ö±íµÄ¹ØÁª¹Øϵ.
5)µ¥»÷"Database"->"Configure Connections"
6)ÔÚµ¯³öµÄODBCÊý¾ÝÔ´¹ÜÀíÆ÷ÖÐ,µã»÷"Ìí¼Ó",Ìí¼ÓÒ»¸öÊý¾ÝÔ´
´ÓÉÏͼ¿ÉÒÔ¿´³ö,ÒѾ³É¹¦Ìí¼ÓÁËÒ»¸öÃûΪtestµÄsql serverÊý¾ÝÔ´.
7)µã»÷"Database"->"Connect..",Á¬½Óµ½¸Õ²ÅÌí¼ÓµÄÊý¾ÝÔ´.
8)µã»÷"Database"->"Generate Database",½«±í´´½¨µ½Êý¾Ý¿â
ÔÚÉÏÃæµÄ¶Ô»°¿òÖÐ,¿ÉÒÔÑ¡ÔñÉú³É½Å±¾µÄĿ¼ºÍÎļþÃû,ÏÂÃ滹ÓкܶàÑ¡Ïî,ÎÒ±£³ÖÁËĬÈÏÑ¡Ïî.×¢ÒâÑ¡ÖÐ"Script generation",Ö»Éú³É½Å±¾,Ñ¡ÖÐ"ODBC generation"»áÌáʾÄãÖ´Ðнű¾µ½Êý¾Ý¿â.
µã»÷Run¿ÉÒÔÔËÐнű¾,Ò²¿ÉÊÖ¶¯Ð޸Ľű¾ºóÔÙRun.RunÁËÖ®ºó,ÔÙµ½Êý¾Ý¿â²é¿´,·¢ÏÖ±íºÍ±íÖ®¼äµÄ¹ØÁª¹ØϵÒѾ´´½¨ÁË.
2¡¢½«ÒÑÓеÄÊý¾Ý¿âµ¼³öµ½PowerDesignerÖÐΪÊý¾ÝÄ£ÐÍ
1£©Ð½¨Ò»¸öphysical data model,ÃüÃûΪtest2
2)µã»÷"Database"->"Connect.."Á¬½ÓÊý¾ÝÔ´¡£
3£©µã»÷"Database"->"Reverse Engineer Database..."
4)Using an ODBC data source
5)µã»÷"È·¶¨"ºó£¬¿ÉÒÔ¿´µ½ÏÂÃæµÄ¶Ô»°¿ò£¬Ñ¡ÏîµÄÒâ˼ҲºÜÃ÷ÁË£¬Ä¬ÈÏֻѡÖÐÁ˵¼³ö±í£º
6£©"OK"Ö®ºó¿ÉÒÔ¿´µ½µ¼Èë¹ö¶¯Ìõ£¬Íê³ÉÖ®ºó£¬¿ÉÒÔ¿´µ½Êý¾Ý¿â±íÒѵ¼ÈëΪÊý¾ÝÄ£ÐÍ¡£
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......
ÒÔÏÂתÔØ£¬ÔÎÄÕª×Ôhttp://www.cnblogs.com/fubeidong/archive/2007/07/06/526247.html
Êý¾Ý¿âÖÐÓиö×ֶνÐorderTime£¬ÊÇDateTimeÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÎÒÃÇÓÃÒÔÏÂSQLÓï¾ä°ÑËüÈ¡³öÀ´£º
select
orderTime
from orders
Ôò»á°Ñʱ¼ä¶¼ÏÔʾ³öÀ´£¬¶øÈç¹û¸Ä³ÉÏÂÃæµÄSQLÓï¾ä£º
select
orderTime = convert(varchar(10),orderTime, ......
½ñÌìÏëÁ¬½ÓSQL Server·þÎñÆ÷ʱ·¢ÏÖû·¨Á¬½Ó£¬·¢Ïֶ˿ںŲ»ÊÇĬÈϵĶ˿ںţ¬ÐèÒªÖ¸¶¨¶Ë¿ÚºÅ£¬¸Õ¿ªÊ¼ÒÔΪÊÇIPµØÖ·¼ÓðºÅÔٶ˿ںžÍÐÐÁË£¬½á¹û·¢ÏÖûÓã¬googleÒ»°Ñ·¢ÏÖÔÀ´²»ÊÇðºÅ£¬ÊǶººÅ£¬¹þ¡£±ÈÈ磺127.0.0.1,1451 , ¸ñʽ¾ÍÊÇ£º[IP],[Port] ¡£ Íê±Ï¡£ ......
Ò»¡¢Ö÷ÒªÊÇÐèÒª¸üÐÂmssqlServer µÄʱºòÐèÒª½øÐÐһЩÊÇ·ñ´æÔÚµÄÅжϣ¬ÔÚmssql2000 ºÍ 2005 ÉϲâÊÔûÓÐŶÎÊÌâ
--//ÅжÏÊDZíTable_UserInfoÀïÊÇ·ñÓÐ×Ö¶Î
if not exists(select * from syscolumns where id=object_id('Table_UserInfo') and name='Tel') begin
ALTER table Table_UserInfo add Tel varchar(200)--Ôö¼Ó×Ö¶Î
......
SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓë ......