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

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Ëùʾ£¬µ±ËùÓмì²â¶¼Í¨¹ýÖ®ºó²ÅÄܼÌÐøÏÂÃæµÄ°²×°¡£Èç¹û³öÏÖ´íÎó£¬ÐèÒª¸üÕýËùÓÐʧ°Üºó²ÅÄÜ°²×°¡£


Ïà¹ØÎĵµ£º

Sql Server ¶ÔxmlÀàÐ͵IJÙ×÷

 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> ......

SQL Óï¾äΪ±íÔö¼Ó,ÐÞ¸Ä,ɾ³ýÁÐ

1.ÐÞ¸ÄÁÐ
    EXEC sp_rename 'TableName.ColumnName','NewColumName'
2.Ôö¼ÓÁÐ
    ALTER TABLE TableName ADD ColumnName int  --Type In Here
3.ɾ³ýÁÐ
    ALTER TABLE TableName DROP Column ColumnName ......

»ùÓÚSQLµÄ·ÖÒ³

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Öв»Ê¶±ð£¬Ð趨Òå±äÁ¿À´Ìæ»»¡· ......

ORACLE SQL ÓÅ»¯

http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
ÇøרÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......

ÔÚSQL Server ɾ³ýÖظ´Êý¾Ý

ɾ³ýÊý¾Ý¿â±íÖÐ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ