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

¡¾Ï뿼¸öMSSQLÈÏÖ¤-×Éѯ¡¿

RT
ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ?
×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿

Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É

µ±È»ÊÇMICROSOFTµÄMCSEÁË

..

°ï¶¥

°ï¶¥Ï°ɡ£¡£

MS SQL ÈÏÖ¤
2000:mcdba
2005:·ÖÈý¸öϵÁР ¹ÜÀí  ¿ª·¢    ÉÌÒµÖÇÄÜ      ¸÷ÓÐÁ½¸ö¼¶±ð mcts  mcitp
ÏêϸÇé¿ö£¬ÔÚ΢ÈíÍøÕ¾ÉÏ¿´

SQL Server 2005΢ÈíÈÏÖ¤¼¼Êõר¼ÒϵÁУ¨MCITP£©
1£©¡¢sql2005Êý¾Ý¿âר¼Ò£º¿¼3ÃÅ
  µÚÒ»ÃÅ£º070-431--- sql2005ʵʩÓëά»¤
  µÚ¶þÃÅ£º070-443--- sql2005Éè¼ÆÊý¾Ý·þÎñÆ÷»ù´¡¼Ü¹¹
  µÚÈýÃÅ£º070-444--- sql2005ÓÅ»¯²¢Î¬»¤Êý¾Ý¿â¹ÜÀí½â¾ö·½°¸Êý
Èç¹ûÄúÒÑÓµÓÐMCDBAÈÏÖ¤£¬¿ÉÒÔͨ¹ý070-447Éý¼¶¿¼ÊÔ½«ÄúµÄ¼¼ÄÜÉý¼¶¡£
2£©¡¢sql2005Êý¾Ý¿â¿ª·¢×¨¼Ò£º¿¼3ÃÅ
  µÚÒ»ÃÅ£º070-431---sql2005ʵʩÓëά»¤ 
  µÚ¶þÃÅ£º070-441--- sql2005Éè¼ÆÊý¾Ý¿â½â¾ö·½°¸
  µÚÈýÃÅ£º070-442--- sql2005Éè¼Æ²¢ÓÅ»¯Êý¾Ý´æÈ¡
3£©¡¢sql2005Êý¾Ý¿âÉÌÒµÖÇÄܽâ¾ö·½°¸¿ª·¢×¨¼Ò£º¿¼3ÃÅ
  µÚÒ»ÃÅ£º070-431---sql2005ʵʩÓëά»¤
  µÚ¶þÃÅ£º070-445--- sql2005·ÖÎö·þÎñÉè¼ÆÉÌÒµÖÇÄÜ
  µÚÈýÃÅ£º070-446--- sql2005Éè¼ÆÉÌÒµÖÇÄÜ»ù´¡¼Ü¹¹
http://www.microsoft.com/china/learning/mcp/mcitp/default.mspx



¸öÈËÊÇÏ뿼 2005 »òÕß2008

²»ÖªµÀÄĸöºÃ¡£¡£×Éѯ

ÒýÓÃ
¸öÈËÊÇÏ뿼2005 »òÕß2008

²»ÖªµÀÄĸöºÃ¡£¡£×Éѯ
2008

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

mssqlÊý¾Ýµ¸Èëmysql

´ÓÍøÉÏ¿´Á˺ܲ»ÉÙÕâ·½ÃæµÄ˵·¨£¬¶ÔÎÒÀ´ËµÓô¦²»ÊǺܴó¡£ÏÖÔÚ½«Ò»¸ösql serverµÄÊý¾Ý¿âÀïµÄÊý¾Ýµ¼Èëµ½mysqlÖУ¬ÀïÃæµÄ×Ö¶ÎÓÐËù¸Ä¶¯µÄ¡£×Ô¼ºÐ´ÁËÒ»¸öµ¼ÈëµÄ²»ÊǺÜÀíÏ룬ÀÏÊǶªÊý¾Ý£¬²»ÖªµÀÊÇʲôԭÒò£¬»¹Íû¸ßÊÖûָµã° ......

mssql ÅÅÐòÎÊÌ⣿ÇóÖú


select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc

ÕâÀï²éѯ 15·ÖÖÓÔÚÏßµÄÈÎÎñ ͨ¹ýrankºÍaddtasktimeÅÅÐò

rankÊýֵΠ......

mssqlÓï¾äµÄÎÊÌâ

Á½¸ö±í
±íA  UserID,Info1,Info2,¼°ÆäËû¼¸¸ö×Ö¶Î
±íB  UserID,Info1,Info2

±íAÀïÃæµÄÊý¾Ý£¬±íBÀïÃæ²»Ò»¶¨´æÔÚ
ÈçºÎÊä³öÕâÖÖ½á¹û

ÁÐ UserID,±íA Info1£¬±íA Info2£¬±íB Info1,±íB ......

mssql job²»ÄÜÖ´ÐÐ

¸÷λ´óÏÀ  £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec  proc_showresult.
¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôԭÒò°¡  Çë¸ßÊÖÖ¸½Ì
´æ´¢¹ý³ÌÓвÎÊýû??
Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......

MSSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆ

MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION

ÓÐË­ÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ
ÒýÓÃ
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ