Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 to Oracle, text×Ö¶ÎÔõô´¦Àí

MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö

sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£

ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ

× ......

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


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

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

rankÊýֵΠ......

MSSQL 2005 Êý¾Ý¿â»Ö¸´Ê§°Ü

²»ÖªµÀÊÇʲôԭÒòʧ°ÜÁË

ÈçÏÂͼËùʾ£º


Èç¹ûͼƬ˵µÁÁ´¿ÉÒÔ½øÈëÒÔÏÂÁ´½Ó£º
http://hiphotos.baidu.com/z789017890/pic/item/890d6cf0c6996482a40f5282.jpg

ÏȸÐлÄãµÄ°ïÖú~~
Á´½ÓÒ²µÁÁ´ ......

mssqlÔõôµÃµ½×Ô¶¯±àºÅidÖµ£¿

Çë´ó¼Ò¸ø¸öÀý×Ó¿´¿´£¬²»ÖªµÀÈçºÎÈ¥´¦Àí£¬ºÍmysql²»Ò»ÑùûÓÐרÃŵĺ¯Êý
SQL code:
id INT AUTO_INCREMENT

?

ÔÚ×öÒ»¸öÌí¼Ó¼Ç¼£¬½á¹û×Ô¶¯±àºÅµÄidÎÞ·¨´¦Àí£¬Â¥ÉϵÄÄÜÔÙÏêϸµãÂð£¿

ÎÞ·¨´¦ÀíÊÇʲôÒâ˼£¿ ......

vb+mssql²éѯÎÊÌâ2

±ÈÈç
Ò»¸öÊÇÓû§Áбí
UserID
1
2
3
4

Ò»¸öÊǼǼÁбí(ÿ¸öÓû§Ò»Ìì¿ÉÄÜÓжàÌõÊý¾Ý)
UserID Day
1 2009-09-22
1 2009-09-22
1 2009-09-22

2 2009-09-22
2 20 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ