Microsoft SQL Server 2008°²×°Í¼½â(Windows 7)
Microsoft SQL Server 2008
°²×°Í¼½â(Windows 7)
FoxDie
2010Äê04ÔÂ17ÈÕ
¼ò½é
±¾ÎÄÏêϸ¼Ç¼ÁËÒ»´ÎÍêÕûµÄMicrosoft SQL Server 2008ÔÚWindows 7²Ù×÷ϵͳÉϵݲװ¹ý³Ì¡£×¢Ò⣺Microsoft SQL Server 2008ÓëWindows 7²Ù×÷ϵͳ´æÔÚÒ»¶¨µÄ¼æÈÝÐÔÎÊÌ⣬ÔÚÍê³É°²×°Ö®ºóÐèҪΪMicrosoft SQL Server 2008°²×°SP1²¹¶¡¡£ÏÂÃ潫Ïêϸ˵Ã÷Õû¸ö°²×°¹ý³Ì¡£
°²×°ÈÕÖ¾
ÔÚWindows7²Ù×÷ϵͳϵ£¬Æô¶¯Microsoft SQL 2008°²×°³ÌÐòºó£¬ÏµÍ³¼æÈÝÐÔÖúÊÖ½«ÌáʾÈí¼þ´æÔÚ¼æÈÝÐÔÎÊÌ⣬ÔÚ°²×°Íê³ÉÖ®ºó±ØÐë°²×°SP1²¹¶¡²ÅÄÜÔËÐУ¬Èçͼ1-1Ëùʾ¡£ÕâÀïÑ¡Ôñ“ÔËÐгÌÐò”¿ªÊ¼SQL Server 2008µÄ°²×°¡£
ͼ1-1¼æÈÝÐÔÎÊÌâÌáʾ
½øÈëSQL Server°²×°ÖÐÐĺóÌø¹ý“¼Æ»®”ÄÚÈÝ£¬Ö±½ÓÑ¡Ôñ½çÃæ×ó²àÁбíÖеē°²×°”£¬Èçͼ1-2Ëùʾ£¬½øÈë°²×°ÁбíÑ¡Ôñ¡£
ͼ1-2SQL Server°²×°ÖÐÐÄ-¼Æ»®
Èçͼ1-3Ëùʾ£¬½øÈëSQL Server°²×°ÖÐÐÄ-°²×°½çÃæºó£¬ÓÒ²àµÄÁбíÏÔʾÁ˲»Í¬µÄ°²×°Ñ¡Ïî¡£±¾ÎÄÒÔȫа²×°ÎªÀý˵Ã÷Õû¸ö°²×°¹ý³Ì£¬Òò´ËÕâÀïÑ¡ÔñµÚÒ»¸ö°²×°Ñ¡Ïî“È«ÐÂSQL Server¶ÀÁ¢°²×°»òÏÖÓа²×°Ìí¼Ó¹¦ÄÜ”¡£
ͼ1-3 SQL Server°²×°ÖÐÐÄ-°²×°
Ñ¡Ôñȫа²×°Ö®ºó£¬ÏµÍ³³ÌÐò¼æÈÝÖúÊÖÔÙ´ÎÌáʾ¼æÈÝÐÔÎÊÌ⣬Èçͼ1-4Ëùʾ¡£Ñ¡Ôñ“ÔËÐгÌÐò”¼ÌÐø°²×°¡£
ͼ1-4 ¼æÈÝÐÔÎÊÌâÌáʾ
Ö®ºó½øÈë“°²×°³ÌÐòÖ§³Ö¹æÔò”°²×°½çÃ棬°²×°³ÌÐò½«×Ô¶¯¼ì²â°²×°»·¾³»ù±¾Ö§³ÖÇé¿ö£¬ÐèÒª±£Ö¤Í¨¹ýËùÓÐÌõ¼þºó²ÅÄܽøÐÐÏÂÃæµÄ°²×°£¬Èçͼ1-5Ëùʾ¡£µ±Íê³ÉËùÓмì²âºó£¬µã»÷“È·¶¨”½øÐÐÏÂÃæµÄ°²×°¡£
ͼ1-5 °²×°³ÌÐòÖ§³Ö¹æÔò
½ÓÏÂÀ´ÊÇSQL Server2008°æ±¾Ñ¡ÔñºÍÃÜÔ¿Ìîд£¬±¾ÎÄÒÔ“Enterprise Evaluation”ΪÀý½éÉÜ°²×°¹ý³Ì£¬ÃÜÔ¿¿ÉÒÔÏòMicrosoft¹Ù·½¹ºÂò£¬Èçͼ1-6Ëùʾ¡£
ͼ1-6 ²úÆ·ÃÜÔ¿
ÔÚÐí¿ÉÌõ¿î½çÃæÖУ¬ÐèÒª½ÓÊÜMicrosoftÈí¼þÐí¿ÉÌõ¿î²ÅÄÜ°²×°SQL Server2008£¬Èçͼ1-7Ëùʾ¡£
ͼ1-7 Ðí¿ÉÌõ¿î
½ÓÏÂÀ´½«½øÐа²×°Ö§³Ö¼ì²ì£¬Èçͼ1-8Ëùʾ£¬µã»÷“°²×°”¼ÌÐø°²×°¡£
ͼ1-8 °²×°³ÌÐòÖ§³ÖÎļþ
Èçͼ1-9Ëùʾ£¬µ±ËùÓмì²â¶¼Í¨¹ýÖ®ºó²ÅÄܼÌÐøÏÂÃæµÄ°²×°¡£Èç¹û³öÏÖ´íÎó£¬ÐèÒª¸üÕýËùÓÐʧ°Üºó²ÅÄÜ°²×°¡£
Ïà¹ØÎĵµ£º
declare @XML XML
SET @XML='<root>
<OLDVALUE>
<H_Action id="1130">030</H_Action>
<D_Action>030</D_Action>
<OrderCompany>00220</OrderCompany>
<OrderNumber>10004035</OrderNumber> ......
1.ÐÞ¸ÄÁÐ
EXEC sp_rename 'TableName.ColumnName','NewColumName'
2.Ôö¼ÓÁÐ
ALTER TABLE TableName ADD ColumnName int --Type In Here
3.ɾ³ýÁÐ
ALTER TABLE TableName DROP Column ColumnName ......
select top PageSize * from ±í
where Ìõ¼þ and id not in
(select top PageSize*(CurrentPageIndex-1) id from ±í where Ìõ¼þ order by ÅÅÐòÌõ¼þ)
order by ÅÅÐòÌõ¼þ
¡¶PageSize ÊÇGridViewÖÐÿҳÏÔʾµÄÐÅÏ¢ÌõÊý£¬PageSize*(CurrentPageIndex-1) ÔÚSQLÖв»Ê¶±ð£¬Ð趨Òå±äÁ¿À´Ìæ»»¡· ......
http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
ÇøרÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......
ɾ³ýÊý¾Ý¿â±íÖÐijһ×ֶεÄÖظ´¼Í¼£¬Ö»Ïë±£ÁôÒ»Ìõ¼Ç¼¿ÉÓÃÒÔÏ·½·¨£º
Ö´ÐÐÒÔÏÂÓï¾ä£º
declare @max integer,@id varchar(18) --´Ë´¦±äÁ¿ÀàÐ͸ù¾Ý×Ö¶ÎÀàÐÍÉèÖÃ
declare cur_rows cursor local for select ×Ö¶Î,count(*) from ±íÃûgroup by ×ֶΠhaving count(*) > 1
open cur_rows
fetch cur_rows into @id,@max
wh ......