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 ......
SQL ServerÊý¾Ý¿âÖвð·Ö×Ö·û´®º¯ÊýµÄ¾ßÌå·½·¨£º
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
¡¡¡¡CREATE¡¡ FUNCTION uf_StrSplit '1.1.2.50','.'
¡¡¡¡(@origStr varchar(7000),¡¡ --´ý²ð·ÖµÄ×Ö·û´®
¡¡¡¡@markStr varchar(100))¡¡¡¡--²ð·Ö±ê¼Ç£¬Èç','
¡¡¡¡RETURNS @splittable table
¡¡¡¡(
¡¡ ¡¡str_id¡¡¡¡varchar(4000) NOT NULL, --±àºÅID ......
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Ä㶼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâƪÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......
--ÐÐÁÐת»» ÐÐתÁÐ
DROP TABLE t_change_lc;
CREATE TABLE t_change_lc (card_code VARCHAR2(3), q NUMBER, bal NUMBER);
INSERT INTO t_change_lc
SELECT '001' card_code, ROWNUM q, trunc(dbms_random.VALUE * 100) bal from dual CONNECT BY ROWNUM <= 4
UNION
SELECT '002' card_code, ROWNUM q, trunc(d ......