SQL Server 2008ʹÓà - MS-SQL Server / »ù´¡Àà
×î½ü×°Á˸öSQL Server 2008£»²»¹ýÎÒÓõÄÖ»Êǿͻ§¶Ë£¬Ò»¾ä¼òµ¥µÄselect * from table ×ÜÊÇÌáʾÎÞ·¨Æô¶¯T-SQLµ÷ÊÔ£»Î´½Óµ½·þÎñÆ÷£¬µÇ¼ʧ°Ü£»
µ«ÎÒÃ÷Ã÷¶¼¿´µ½ÉÏÃæµÄÊý¾Ý¿âºÍ±íÁË£»
ÔõôûÈËÖ§Õа¡
ûÓÐÓùý sql 08,°ï¶¥+ѧϰ¡£¡£¡£¡£¡£¡£ÅθßÊÖ½â´ð¡£¡£
¹ÖÊ£¬ÖØÆôSQL·þÎñÊÔÏ¡£
ÄãÓõÄʲôÕË»§µÇ¼µÄ£¿Èç¹ûÊÇwindowsÕË»§µÇ¼µÄ£¬ÊÔÊÔ¸ÄÓÃsql serverÕË»§µÇ¼£¬²¢ÇÒ±£Ö¤µÇ¼µÄÕË»§ÒªÓÐsql serverÖÐsysadminµÄȨÏÞ
¸Õ²ÅÊÔÁËÏ£¬°´ÄÇÀïÃæµÄÖ´Ðа´Å¥Ê±¾ÍÐÐÁË£¬°´µ÷ÊÔ¾ÍÊÇÉÏÃæËµµÄÎÊÌ⣻ÕâÊÇÔõô¸ãµÄ°¡?
¼ÌÐø¹Ø×¢¡£¡£°ï¶¥£¡
¾ÍûÈË»áÂð£¬Ã»ÈËÃ÷°×Âð£¿
¹þ¹þ¹þлл À´¿´¿´ ѧϰµÄ
¹Ø×¢Öа¡
ȷʵûÓÐÓöµ½¹ý¡£ °ï¶¥¡·¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......