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 --- ¾µä·¾«²Ê
Êý¾Ý²Ù×÷Àà SQLHelper.cs
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì
°ÙÍò¼¶·ÖÒ³´æ´¢
SQL¾µä¶ÌС´úÂëÊÕ¼¯
ѧÉú±í ¿Î³Ì±í ³É¼¨±í ½Ìʦ±í 50¸ö³£ÓÃsqlÓï¾ä
SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»
Óαê
¸ù¾Ý²»Í¬µÄÌõ¼þ²éѯ²»Í¬µÄ±í
INNER JOIN Óï·¨
master.dbo.spt_val ......
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 ......
¹¤¾ß£º
Sybase PowerDesigner 12.5
Microsoft SQL Server 2005
µÚÒ»²½£º¸ÅÒªÉè¼Æ
´ò¿ªPowerDesignerÈí¼þ£¬Éè¼Æ“¸ÅÄîÊý¾ÝÄ£ÐÍ”(Conceptual Data Model)£º
ͼ1
Éè¼Æ±í½á¹¹£º
ͼ2
ÔÚÉè¼ÆÊôÐÔ(×Ö¶Î)µÄʱºò£¬Èý¸ö×Öĸ(M¡¢P¡¢D)·Ö±ð±íʾ£º
M£ºÊÇ·ñΪ¿Õ;(√±íʾ²»ÔÊÐíΪ¿Õ)
P£ºÊÇ·ñ뻅 ......