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 ÀàÐÍÆäʵ¾ÍÊÇСÊýÀàÐÍ decimal £¬ÎÒ²»Ï²»¶ÓÃËü£¬ÒòΪÓÐÒ»´Îʲô¹¤¾ßÉú³É£¬·¢ÏÖËü×Ô¶¯°ÑmoneyÀàÐÍת»»³ÉÁËdecimalÀàÐÍÁË£¬ÓëÆäÈÃËüת£¬»¹²»Èç×Ô¼ºÉè¼ÆÊý¾Ý¿âʱ½«»õ±ÒÀàÐÍ×Ö¶ÎÉèÖÃΪ decimal ÀàÐͲ»¾ÍµÃÁË£¬·ÏÄÇʸÉÂ ×Ö½ÚÊý ³¤¶È(СÊýµãÇ°.СÊýµãºó) ......
drop table #Tmp --ɾ³ýÁÙʱ±í#Tmp
create table #Tmp --´´½¨ÁÙʱ±í#Tmp
(
ID int IDENTITY (1,1) not null, --´´½¨ÁÐID,²¢ÇÒÿ´ÎÐÂÔöÒ»Ìõ¼Ç¼¾Í»á¼Ó1
WokNo &nb ......
Óû§×Ô¶¨Ò庯Êý£¨User Defined Functions£©ÊÇSQL Server µÄÊý¾Ý¿â¶ÔÏó£¬Ëü²»ÄÜÓÃÓÚÖ´ÐÐһϵÁиıäÊý¾Ý¿â״̬µÄ²Ù×÷£¬µ«Ëü¿ÉÒÔÏñϵͳº¯ÊýÒ»ÑùÔÚ²éѯ»ò´æ´¢¹ý³ÌµÈµÄ³ÌÐò¶ÎÖÐʹÓã¬Ò²¿ÉÒÔÏñ´æ´¢¹ý³ÌÒ»Ñùͨ¹ý EXECUTE ÃüÁîÀ´Ö´ÐС£Óû§×Ô¶¨Ò庯ÊýÖд洢ÁËÒ»¸öTransact-SQL Àý³Ì£¬¿ÉÒÔ·µ»ØÒ»¶¨µÄÖµ¡£
¡¡¡¡ÔÚSQL Server Öиù¾Ýº ......
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Ä㶼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâƪÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃ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 ......