Çósql log explore - MS-SQL Server / »ù´¡Àà
Çósql log explore
ÏÂÔØÇøÓеģ¡ÄãÕÒÕÒ£¡ÒýÓà 4.2 ÏÂÔØµØÖ·£ºhttp://download.csdn.net/source/2284248 ÎÒÓùý4.1µÄ£¬Ëƺõ²»Ö§³Ösql2005¡£Õâ¸ö4.2Ö§³ÖÂð ........................
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º DECLARE @STR NVARCHAR(MAX) SET @STR='SELECT * from SALE_PROD' ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿ Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡ ¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡ Ö±½ÓÖ´ÐоÍÐÐÁË exec ......
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......
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Õ¾Àï ±¾ÉíÓÐ ......