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

SQL Server 2008 r2 °²×°¹ý³Ì¼Ç¼

×òÍí£¬µ½Î¢Èí¹Ù·½ÏÂÁËÒ»¸ö32°æ±¾µÄTrial°æ±¾¡£ÎļþÃûΪSQLFULL_x86_ENU.exe¡£Îļþ´óСΪ1.30G×óÓÒ¡£ÒòΪֻÓÐ32λһ¸ö°æ
±¾£¬±ÈSQL Server  2008ÄǸö3GµÄҪС¶àÁË¡£ºÇºÇ¡£
http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx 
ÏÂ
ÔØÍê³Éºó£¬ÏÈжÔØÔ­À´µÄSQL Server 2008¡¡sp2,½á¹ûÕûÕûÔËÐÐÁËÁ½¸öСʱ£¬ÒòΪSQL
Server¡¡2008µÄ°²×°»úÖÆÊÇ»ùÓÚframeworkÖØдµÄ£¬ÌصãÊǷdz£ºÄʱ¼ä(ÎÒµÄС±¾±¾ÅäÖû¹ÊÇ¿ÉÒԵġ£^_^)¡£µ«²»ÐèÒªÔ­ISO»òÒþ²ØÆðÀ´
µÄMSIÎļþ(Èç¹ûÄ㲻СÐÄÊÖ¹¤É¾³ýÕâЩ°²×°ÎļþµÄ»°£¬Ò²²»±Øµ£ÐÄ¡££© ÕâÒ²ÊÇΪʲô´ó¶àÊýʱºò£¬SQL Server
2008µÄ°²×°ÈÕÖ¾Îļþsetup.log»áÓÐ1G´óСµÄÔ­Òò¡£ÒòΪ°²×°¹¤ÐòʵÔÚÊÇÌ«ÅÓ´óÁË¡£
ÑÔ¹éÕý´«¡£Ð¶ÔØÍê³Éºó£¬ÖØÆô»úÆ÷¡£×¢
Ò⣬ÒòΪÒÔÇ°Ôø¾­°²×°¹ýSQL Server¡¡2008£¬ËùÒÔһЩ×é¼þÈç.net Framework sp1µÈ²»±ØÔÙ°²×°¡£
¿ÉÒÔ
²Î¿´£º
°²×°sql2008 enterprise (EnglishÕýʽ°æ)ͼ½â
ÏÂÃæÊÇSQL Server 2008
r2µÄ°²×°¹ý³Ì,ÆäʵÓëSQL server 2008µÄ°²×°·Ç³£ÀàËÆ£¬Ö»ÊÇÒÔÇ°µÄ½Øͼ̫Óеã¶Ô²»Æð¹ÛÖÚ£¬Ìش˵ÀǸ£¡
 
 
 
 
 
 
 
 
 
 
 
 
 
ÑûÔÂ×¢£º±¾ÎÄ°æȨÓÉÑûÔÂ
ºÍCSDN¹²Í¬ËùÓУ¬×ªÔØÇë×¢Ã÷³ö´¦¡£
ÖúÈ˵ÈÓÚ×ÔÖú!  
3w@live.cn


Ïà¹ØÎĵµ£º

¡¾»ã×Ü¡¿SQL CODE ¾­µä·¾«²Ê


¡¾»ã×Ü¡¿SQL CODE --- ¾­µä·¾«²Ê
Êý¾Ý²Ù×÷Àà SQLHelper.cs
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì
°ÙÍò¼¶·ÖÒ³´æ´¢
SQL¾­µä¶ÌС´úÂëÊÕ¼¯ 
ѧÉú±í ¿Î³Ì±í ³É¼¨±í ½Ìʦ±í 50¸ö³£ÓÃsqlÓï¾ä
SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»
 
Óαê
¸ù¾Ý²»Í¬µÄÌõ¼þ²éѯ²»Í¬µÄ±í
INNER JOIN Óï·¨
master.dbo.spt_val ......

sql´æ´¢

declare @p int
declare @p1 int
declare @count int
set @p=0
set @p1=10
set @count=2
if(@count<>0 or @count<>1)
set @p=@p1*@count-10
SELECT [t1].[userid], [t1].[username], [t1].[userorder]
from (
    SELECT ROW_NUMBER() OVER (ORDER BY [t0].[userorder]) AS [ROW_NU ......

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

¹¤¾ß£º
Sybase PowerDesigner 12.5
Microsoft SQL Server 2005
µÚÒ»²½£º¸ÅÒªÉè¼Æ
´ò¿ªPowerDesignerÈí¼þ£¬Éè¼Æ“¸ÅÄîÊý¾ÝÄ£ÐÍ”(Conceptual Data Model)£º
 
ͼ1
Éè¼Æ±í½á¹¹£º
 
ͼ2
ÔÚÉè¼ÆÊôÐÔ(×Ö¶Î)µÄʱºò£¬Èý¸ö×Öĸ(M¡¢P¡¢D)·Ö±ð±íʾ£º
M£ºÊÇ·ñΪ¿Õ;(√±íʾ²»ÔÊÐíΪ¿Õ)
P£ºÊÇ·ñ뻅 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ