Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ServerÊý¾Ý¿âÖвð·Ö×Ö·û´®º¯Êý

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ÊÕ²Ø)

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

Oracle SQL¾«ÃîSQLÓï¾ä½²½â


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