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

VistaÏ°²×°SQL SERVER 2005 EXPRESS

 Vista³öÁËÃûµÄ¼æÈÝÐÔÎÊÌâ¶à£¬ºÜ¶àÈËÒ²¿àÓÚSQL SERVER²»ÄÜ°²×°ÔÚVistaÏ¡£ÏÖÔÚÎÒ½«×Ô¼ºµÄ°²×°¹ý³Ì˵Ï£º
²Ù×÷ϵͳ£ºWindows Vista Home Basic
´¦Àíµ¥Ôª£ºInter P8600 2.40GHz
Ö÷´æ´¢Æ÷£º2G
Íâ´æ´¢Æ÷£º250G
Èí¼þ×¼±¸£º£¨¶¼¿ÉÒÔÔÚ΢Èí¹Ù·½ÍøÕ¾ÕÒµ½£¬¾ùÃâ·Ñ£©
    1.SQL SERVER 2005 EXPRESS£¨40.6M£©
    2.SQL SERVER 2005 SP2£¨297M£©
    3.SQL SERVER Management Studio 2005 Express£¨44.7M£©
°²×°¹ý³Ì£º
    1.ÏÈ°²×°SQL SERVER 2005 EXPRESS£¬°²×°Ê±¸ÃÈí¼þ»á×Ô¶¯¼ì²âÄãµÄ»úÆ÷ÊÇ·ñÊʺϰ²×°£¬ÒòΪEXPRESSÊÇ°²×°ÒªÇó×îµÍµÄÒ»¸ö°æ±¾£¬ËùÒÔÒ»°ã¶¼ÄÜͨ¹ý¼ì²éµÄ¡£°²×°¹ý³ÌÖлáÒªÇóÌîдʵÀýÃûµÈ¶«Î÷£¬¶¼Ä¬ÈϾÍÐÐÁË¡£
       ×¢£ºÈç¹ûÌîдÁËʵÀýÃû£¬ÄÇô·þÎñÆ÷Ãû¾ÍΪ£º“»úÆ÷Ãû\ʵÀýÃû”£¬·ñÔò·þÎñÆ÷ÃûΪ£º“»úÆ÷Ãû\SQLEXPRESS”£¬ºÜ¶àÈ˾ÍÊÇÕâÀïûעÒâµ¼ÖÂÁ¬½Ó²»ÁË·þÎñÆ÷¡£
   
    2.°²×°SQL SERVER 2005 SP2¡£Õâ¸ö×°Íêºó»áÌáʾÅäÖÃSQL SERVER¡£¸ú×ÅÏòµ¼¾ÍÐÐÁË
    3.Èç¹ûÄã²»ÏëÔÚÃüÁîÐÐÔËÐÐSQLÓï¾ä£¬ÄÇôÌøµ½µÚÎå²½£¬·ñÔò½Ó×Å¿´¾ÍÐÐÁË¡£
    4.°´ÏÂctrl+R“ÔËÐД£ºsqlcmd -S .\SQLEXPRESS¡£Õâʱ¾Í»á³öÏÖÃüÁîÐС£
       ¿ÉÒÔÖ±½ÓÔÚÀïÃæÖ´ÐÐSQLÓï¾ä¡£Óëmysql²»Í¬µÄÊÇ¡£ÄãÔÚÓï¾ä½áÊø´¦´ò“;”£¬È»ºó»Ø³µ²¢²»»áÖ´ÐÐSQLÓï¾ä£¬»¹ÐèÊäÈë“go”£¬Ôٻسµ¡£µ±È»£¬Èç¹ûÄ㲻ϲ»¶ÔÚÕâ¸öºÚºõºõµÄ½çÃæÔËÐÐSQLÓï¾ä¡£¿ÉÒÔ½Ó×Å¿´¡£
    5.°²×°SQL SERVER Management Studio Express£¬Õâ¸öÊÇÕë¶ÔEXPRESS°æ±¾¿ª·¢µÄ¹ÜÀí¹¤¾ß¡£°²×°¿ÉÒÔͨ¹ýÔÚÄãµÄ“³ÌÐò”-¡·“Microsoft SQL Server 2005”-¡·“SQL Server Management Studio Express”´ò¿ªËü¡£
    6.´ò¿ª“SQL SERVER Management Studio Express”£¬ÎҵĻúÆ÷ÃûÊÇ“IBM-PC”£¬Ã»ÓÐÖ¸¶¨ÊµÀýÃû³Æ£¬ËùÒÔ·þÎñÆ÷Ãû³ÆÌî“IBM-PC\SQLEXPRESS”(Èç¹ûÄã´íÁË£¬Çë²Î¿¼µÚÒ»²½µÄ‘×¢’)£¬È»ºóÁ¬½Ó¾ÍOKÁË¡£
 
    7.“SQL SERVER Management Studio Express"Æäʵ¾ÍÊÇSQL SERVER 2000µÄÆóÒµ¹ÜÀíÆ÷ºÍ²éѯ·ÖÎöÆ÷¡£ÔÚ×ó±ßµÄÊÓͼÖпÉ


Ïà¹ØÎĵµ£º

sql server µÄ moneyÀàÐÍ

sql serverµÄ money ÀàÐÍÆäʵ¾ÍÊÇСÊýÀàÐÍ decimal £¬ÎÒ²»Ï²»¶ÓÃËü£¬ÒòΪÓÐÒ»´Îʲô¹¤¾ßÉú³É£¬·¢ÏÖËü×Ô¶¯°ÑmoneyÀàÐÍת»»³ÉÁËdecimalÀàÐÍÁË£¬ÓëÆäÈÃËüת£¬»¹²»Èç×Ô¼ºÉè¼ÆÊý¾Ý¿âʱ½«»õ±ÒÀàÐÍ×Ö¶ÎÉèÖÃΪ decimal ÀàÐͲ»¾ÍµÃÁË£¬·ÏÄÇʸÉÂ   ×Ö½ÚÊý ³¤¶È(СÊýµãÇ°.СÊýµãºó) ......

SQL SERVERÁÙʱ±íµÄʹÓÃ

 drop table #Tmp   --ɾ³ýÁÙʱ±í#Tmp
create table #Tmp  --´´½¨ÁÙʱ±í#Tmp
(
    ID   int IDENTITY (1,1)     not null, --´´½¨ÁÐID,²¢ÇÒÿ´ÎÐÂÔöÒ»Ìõ¼Ç¼¾Í»á¼Ó1
    WokNo     &nb ......

SQLÖ®Óû§×Ô¶¨Ò庯Êý

Óû§×Ô¶¨Ò庯Êý£¨User Defined Functions£©ÊÇSQL Server µÄÊý¾Ý¿â¶ÔÏó£¬Ëü²»ÄÜÓÃÓÚÖ´ÐÐһϵÁиıäÊý¾Ý¿â״̬µÄ²Ù×÷£¬µ«Ëü¿ÉÒÔÏñϵͳº¯ÊýÒ»ÑùÔÚ²éѯ»ò´æ´¢¹ý³ÌµÈµÄ³ÌÐò¶ÎÖÐʹÓã¬Ò²¿ÉÒÔÏñ´æ´¢¹ý³ÌÒ»Ñùͨ¹ý EXECUTE ÃüÁîÀ´Ö´ÐС£Óû§×Ô¶¨Ò庯ÊýÖд洢ÁËÒ»¸öTransact-SQL Àý³Ì£¬¿ÉÒÔ·µ»ØÒ»¶¨µÄÖµ¡£
¡¡¡¡ÔÚSQL Server Öиù¾Ýº ......

SQL ServerÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ(SQLÊÕ²Ø)

Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Ä㶼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâƪÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾­Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......

SQL SERVER´æ´¢¹ý³ÌÖÐʹÓÃÊÂÎñ

 
Create PROCEDURE UpdateWanjun
@UserName nvarchar(500),
@UserPassword nvarchar(500),
@ReturnVal int output
AS   
    --Set XAcT_ABORT ON
   Begin Transaction T
       Update admins set UserPassword = @UserPassword wh ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ